title: SSIS and Passwords
body: <p>I have a number of SSIS packages that are launched by Windows Services.  These packages point to any number of different databases, and the connection information is known only by the service at run-time.</p>
  
  <p>I know that I can't save connection strings inside the package, but it seems that I can't even pass in a complete "connection string" as a variable; when I do, the package errors out and it appears that the password is removed.</p>
  
  <p>What I can do, however, is pass in the parts of the connection string that I need and then re-assemble them into a working connection string.  I do NOT want to do this; it seems sloppy and ill-advised.</p>
  
  <p>Anyone have any thoughts on how to accomplish this?</p>