====== 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. 

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

<WRAP center round important 75%>
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.
</WRAP>

===== Use of ampersands =====
The [[http://www.w3.org/TR/2000/REC-xml-20001006#syntax|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 ''&amp;''. For example:

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

{{tag> SSIS package configuration}}