Configuration Files

SSIS allows you to create configuration files to store and manipulat the configuration data.



1. Go to File Menu options, SSIS >>Package Configurations

2. Check the checbox "Enable Package Configurations"

3. Click on "Add" and then "Next"

4.Select "XML Configuration File" and browse for the path where you want to store the file. It default adds "dtsConfig" as an extension for Config file. Click Next.

5. You see a list of Variables, connection Managers, Package Properties, Event Handlers here. You can check the accompanying checkbox to select the varaibles etc that you wish to keep configurable. Only the checked values are added to config file.



6. Keep the Configurable items to minimum. When you select say a variable, select only the properties of the variable that you wish to configure e.g. Just select Properties "Value" and may be "Description" (You can add a descriiption as to what purpose the variable serves, or any specific instructions that you wish to provide abt the variable).

7.Click Next. Give a name to the Config settings , e.g if this config is meant for Development environment then "Dev-Config" would help you recognise the Config file.