title: Overriding The SSIS Connection Manager ConnectionString During Run-Time
body: <p>I have a SSIS package that I execute several times in parallel from different SQL Server Agent Jobs. I set the ConnectionString to the Connection Manager by using the command line parameter /CONNECTION. </p>
  
  <p>It seems that the SSIS is overriding my run-time ConnectionString again with the design-time value. I also found an MSDN article stating that this is indeed what happens.<br>
  <a href="http://msdn.microsoft.com/en-us/library/bb500430(v=sql.105).aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/bb500430(v=sql.105).aspx</a></p>
  
  <p>Is there a way to override the Connection Manager ConnectionString during run-time? I need this functionality because I'm using the same packages for different setups so I cannot "hard-code" the ConnectionString.</p>