title: Can One SSIS Package use two different XML Config files in the same execution?
body: <p>I've inherited some SSIS Packages that need to be modified for a SQL 2008 R2 to SQL 2012 migration. Unfortunately, the "configuration" was done rather poorly.</p>
  
  <p>We have a global XML Config file for all SSIS Packages, and just a few variables in the XML Config file--Server Name, ODS Server Name, and Environment (Development, Integration, PreProd, and Production).</p>
  
  <p>To "configure", they write code in the SSIS Package: If 'Development' Then ... Else If 'Integration' Then ...</p>
  
  <p>In order to change the "configuration", one has to change the code in the Package.</p>
  
  <p>I have unsuccessfully tried to negotiate a change, but no one is budging so the one XML Config file remains.</p>
  
  <p>If I can add a second XML Config file, with my Package specific variables that need to be configured in each Environment, that's what I will do. However, I have not found a way to do this. Is is possible?</p>
  
  <p>My second choice is put variables in a SQL Server table.</p>