title: SSIS: Overwite the data source/server in a connection string read from a package configuration value
body: <p>I have looked at other posts and questions but I couldn't find what I needed.</p>
  
  <p>I am relatively new to SSIS Package creation so bear with me please.</p>
  
  <p>Basically, I need the package to connect to multiple servers based on a list of IPs read from a table.  I have a connection string that I am reading from a config table.  the connection string is generic in that the datasource is simply 255.255.255.255 and I want to replace the datasource with the IPs read from the table as I loop through during package execution.  </p>
  
  <p>I am using IPs since the servers I am connecting to are not on our domain.  I have set up the server name as a variable within the connection manager expressions.  Thus what I am hoping is that the pkg config is read to obtain the entire connection string. Then as I loop through the IPs, the server name variable will be dynamically substituted into the data source value as it loops thorugh.  I hope this makes sense.</p>
  
  <p>So the connstring is: (generic within config table)</p>
  
  <pre><code>Data Source=255.255.255.255,65000;User ID=test;Password=test;Initial Catalog=myDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-myApp;
  </code></pre>
  
  <p>Then as I obtain the list of IPs I want it to change to and then obviously connect as:</p>
  
  <pre><code>Data Source=1.1.1.1,1000;User ID=test;Password=test;Initial Catalog=myDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-myApp;
  </code></pre>
  
  <p>Then the next IP and connect as:</p>
  
  <pre><code>Data Source=2.2.2.2,1000;User ID=test;Password=test;Initial Catalog=myDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-myApp;
  </code></pre>
  
  <p>How can I do this using SSIS?</p>