March 20, 2023 at 9:29 am
Hello,
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
March 20, 2023 at 4:59 pm
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.
Jeffrey Williams
“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
March 21, 2023 at 5:34 am
Ok, thanks for sharing.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply