Creating and Applying a Configuration

Use a package configuration to override selected property values stored in a separate file or configuration resource. Typically, this is used to apply properties, such as file paths or connection strings, that would need to be changed when the package is moved to a test or production environment.

Adding a Configuration to the Project

You can add a configuration to the Integration Services project by using the SSIS menu in BIDS.

Use the SSIS BIDS Menu to Add a Configuration

1. Select Package Configurations from the menu.

2. Select the Enable Configurations check box in the Package Configurations Organizer dialog box:

   1. Click the Add button to launch the Package Configuration Wizard.

   2. Click Next, and then view the storage locations and formats in the Configuration Type drop-down list:

      • XML Configuration File

      • Environment Variable

      • Registry Entry

      • Parent Package Variable

      • SQL Server

   The values stored in these configurations are applied to the package and component properties when the package is deployed using a deployment utility manifest. You can also apply new property values dynamically to a previously deployed package from a configuration by using Execute Package Utility.