Package configuration files

Runtime configuration information can be supplied to an SSIS package using a package configuration. An easy way to maintain package configuration information is to store it in an XML package configuration file.

When running a package from the command line with dtexec, you can specify the path to a package configuration file using the /ConfigFile argument.

If package configurations are enabled in the built package, SSIS will use the configuration file name specified in the package (and ignore the value specified at runtime). To allow /ConfigFile to be used, disable package configurations before building the package.

The XML standard reserves the ampersand character as a markup delimiter, so if required in a configuration value it must be specified using the character reference &. For example:

<Configuration 
  ConfiguredType="Property" 
  Path="\Package.Variables[User::MyVar].Value" 
  ValueType="String"
>
  <!-- we want "ValueA&ValueB" -->
  <ConfiguredValue>ValueA&amp;ValueB</ConfiguredValue>
</Configuration>