Home Forums Data Warehousing Integration Services SSIS - Dynamic XML Configuration File Path while running the Package RE: SSIS - Dynamic XML Configuration File Path while running the Package

  • At a previous employer we established a fixed directory on the c: drive of our development and production Data Warehouse servers. This fixed directory contained an XML configuration file that was used by our SSIS packages to point to where the actual configuration files resided on each server since this was different between development and production. All our packages looked in this directory to determine where to look for the actual configuration files.

    You could also use a system variable to contain the same information regarding the location of configuration files. We went with the XML file as it was easier to maintain and allowed us to expand locations depending on information in the package as well. IIRC when using a system variable you can only point to one location. You would have to verify that to be sure.