I have 3 SSIS packages having connection manager defined with a userA. These 3 packages executes via a SQL server job.
I need to change the password of userA in all the 3 packages. Do I need to do it manually by opening the package first in Visual studio & updating the password in connection manager? This will also require the pkg re-deployment.
Is there another way of doing this. Can I update the password directly in Sql server job config properties. Please suggest
It depends on how the packages are deployed - if deployed to the catalog you can update the values in the deployed project or update the values in the agent job, or if you have setup environment variables you could update the value in the environment variable.
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Ok, thanks for sharing.
Viewing 3 posts - 1 through 2 (of 2 total)