I have a set of packages and have created a SQL Agent job for scheduling the execution. I am now in the process of moving the code to production server. I have used package configurations in SSIS, so the package takes the DB connections automatically, based
on the dev/test/prod regions. But for the SQL Agent job, I still see the development DB connection string in the 'Data Sources' tab of the SQL Agent. Is there a way to configure the DB connection like in SSIS package?
View Complete Post