Encrypt column value in SSIS Configuration Table

• Spork

  SSC-Addicted

  Points: 460

  More actions

  April 14, 2015 at 8:03 am

  #299758

  I have an SSIS package set up that uses a table for package configuration.

  I change one connection manager in the package as I switch between environments (DEV, QA, PROD); all other configuration values are inserted as rows in the configuration table.

  One of the rows has a username and password used in the package; this value (along with other rows) are changed when moving between environments.

  How can I encrypt the row/column that contains the username/password and then decrypt/read into the SSIS package?

  Thanks.

• Martin Schoombee

  SSCoach

  Points: 19115

  More actions

  April 21, 2015 at 10:24 am

  #1792475

  Seeing that you are storing the configuration values in a database table, you should refer to the SQL Server database encryption options.

  The SSIS forum is probably not the best place if you need questions answered on database encryption.