How to: Add a Package Configuration

SQL Server 2008 Books Online (October 2009)

Package configurations make it possible to update the properties of a package and the objects it contains at run time.

Note:
To become better acquainted with the concepts explained in this section, see Tutorial: Deploying Packages and Lesson 3: Adding Package Configurations of Tutorial: Creating a Simple ETL Package.

To create a package configuration

In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, double-click the package to open it.
In SSIS Designer, click the Control Flow, Data Flow, Event Handler, or Package Explorer tab.
On the SSIS menu, click Package Configurations.
In the Package Configuration Organizer dialog box, select Enable package configurations, and then click Add.
On the welcome page of the Package Configuration Wizard page, click Next.
On the Select Configuration Type page, specify the configuration type, and then set the properties that are relevant to the configuration type. For more information, see Select Configuration Type (Package Configuration Wizard).
On the Select Properties to Export page, select the properties of package objects to include in the configuration. If the configuration type supports only one property, the title of this wizard page is Select Target Property. For more information, see Select Objects to Export (Package Configuration Wizard).

Note:
Only the XML Configuration File and SQL Server configuration types support including multiple properties in a configuration.
On the Completing the Wizard page, type the name of the configuration, and then click Finish.
View the configuration in the Package Configuration Organizer dialog box.
Click Close.

Note:
Only the XML Configuration File and SQL Server configuration types support including multiple properties in a configuration.