title: How to encrypt password stored in [SSIS Configurations] table
body: <p>i am facing big trouble in SSIS. For ease of deployment in production,I configured my ssis package connection string.I stored this connection string in  [SSIS Configurations] table.I use data flow task in SSIS package.Obviously source db and destination DB connection strings are stored in this  [SSIS Configurations] table.When I gave demo to client he said why you are storing password in plain text.At that time I thought of using windows authentication but both of the servers are not connected to any domain.How can I use windows authentication in this case or else is there any way to encrypt password present in   [SSIS Configurations] table.I am using SQLserver 2005.</p>
  
  <p>Please help.</p>