title: Store passwords securely in SQL Server for use with dynamic datasources - SSIS
body: <p>We make heavy use of dynamic datasources. We retrieve server name and database names from a table in a SQL Server database. A package loops through the server names and database names and executes once for every server, for every database. </p>
  
  <p>These values are then put into the <code>ServerName</code> and <code>InitalCatalog</code> fields of the dynamic connection. User and password are pre-defined (and therefore the same for every connection). I would like to fill the user + password from a table too but then I have to store the passwords as clear text in that table. </p>
  
  <p>Is there a way to store the password encrypted in that table and decrypt it when I need to use it? Any person having access to the SSIS package is allowed to know the passwords but they should not be easily read from the table containing the connection strings.</p>
  
  <p>All suggestions to handle this (f.e.  using different approaches)  are very much appreciated !</p>