title: In SSIS XML config, in what places does Servername need to be modified?
body: <p>if you want to manually modify connection manager in package configured generated XML to a different server, exactly where (and in how many places) do you modify the server name? Also, what is the rationale for which places you modify this information? </p>
  
  <p>q1. in the xml below, which i have generated by changing the server name in the connection manager and re-running property configurations, in order to change the server back manually by modifying the XML directly, it appears you would modify the servername after <code>Data Source =</code> and after </p>
  
  <pre><code>Package.Connections[StagingConn].Properties[ServerName]" ValueType="String"&gt;&lt;ConfiguredValue&gt;
  </code></pre>
  
  <p><strong>is this correct?</strong> </p>
  
  <p>q2. the xml below results from changing the connection manager itself and then regenerating the property configurations. the original server was </p>
  
  <blockquote>
    <p>NYCDSTGDWDB01\NADEVSTG1EDW</p>
  </blockquote>
  
  <p>and the changed to server is </p>
  
  <blockquote>
    <p>NYGNACKENSON2\NADEV1EDW</p>
  </blockquote>
  
  <p>what does the section Application 
  <code>Name=SSIS-ExtractCRMStage_BusinessUnit-{8ECEE79B-793C-4E54-A659-C487265700DD}NYCDSTGDWDB01\NADEVSTG1EDW</code> 
  used for and why was the servername not get changed in that place when i switched servers and regenerated the package configuration XML?  </p>
  
  <pre><code>Path="\Package.Connections[StagingConn].Properties[ConnectionString]" ValueType="String"&gt;&lt;ConfiguredValue&gt;**Data Source=**NYGNACKENSON2\NADEV1EDW;Initial Catalog=WeightWatchersStaging;Provider=SQLNCLI10.1;
  Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-ExtractCRMStage_BusinessUnit-{8ECEE79B-793C-4E54-A659-C487265700DD}NYCDSTGDWDB01\NADEVSTG1EDW.WeightWatchersStaging;&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[Description]" ValueType="String"&gt;&lt;ConfiguredValue&gt;&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[InitialCatalog]" ValueType="String"&gt;&lt;ConfiguredValue&gt;WeightWatchersStaging&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[Name]" ValueType="String"&gt;&lt;ConfiguredValue&gt;StagingConn&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[Password]" ValueType="String"&gt;&lt;ConfiguredValue&gt;&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[ProtectionLevel]" ValueType="Int32"&gt;&lt;ConfiguredValue&gt;1&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[RetainSameConnection]" ValueType="Boolean"&gt;&lt;ConfiguredValue&gt;0&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].**Properties[ServerName]" ValueType="String"&gt;&lt;ConfiguredValue&gt;**NYGNACKENSON2\NADEV1EDW&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;Configuration ConfiguredType="Property" Path="\Package.Connections[StagingConn].Properties[UserName]" ValueType="String"&gt;&lt;ConfiguredValue&gt;&lt;/ConfiguredValue&gt;&lt;/Configuration&gt;&lt;/DTSConfiguration&gt;
  </code></pre>