SSIS connection manager password update

  • 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


  • 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

  • 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