How to change Password of all packages in a SSIS project?

• Jobs90312

  Mr or Mrs. 500

  Points: 533

  More actions

  October 14, 2022 at 9:52 am

  Go to Answer

  #4099526

  Hi everyone,

  So I want to know is there anyway to set a password of all packages  of a SSIS project in one go instead of opening each package and changing the password on every package separately?

  Thanks

• frederico_fonseca

  SSCoach

  Points: 16167

  More actions

  October 14, 2022 at 10:43 am

  Answer

  #4099543

  better not to have them with passwords - any sensitive data for connection strings should be on config files (or config environments on SSIS catalog) - if on files they can (and should) also be encrypted.

  but DTUTIL is what you can use - https://learn.microsoft.com/en-us/sql/integration-services/dtutil-utility?view=sql-server-ver16