title: SSIS 2008: Changing a Data Source's Connection String Not Reflecting in Referencing Packages
body: <p>Been struggling with this for quite some time so any help is appreciated. Spent a lot of time looking over MSDN, Google, etc, and still no luck.</p>
  
  <p>I have an SSIS project I intent to always execute from within BID. The project has multiple packages, so I created a Data Source to share amongst all the packages.</p>
  
  <p>In each package, I create a Connection Manager based of that Data Source. Now when I go and edit this Data Source's connection string to point to a different server, the change is NOT reflected in the packages.</p>
  
  <p>Now, MSDN says the opposite. In fact, one of the main purposes of Data Sources is to update connection strings easily from within BID; at least according to MSDN.</p>
  
  <p>And for me its not working. This has got to be the most annoying thing I have seen thus far in BID.</p>
  
  <p>Any one have any suggestions?</p>
  
  <p><strong>UPDATE</strong>
  It looks like BID does not synchronize a Data Source change with Connection Managers if the data source's authentication is SQL server. If it is Windows authentication, it detects the change fine.</p>
  
  <p>Very interesting indeed.</p>