Share via


How to: Create a Package Configuration

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 Deploying Packages Tutorial and Lesson 3: Adding Package Configurations of Creating a Simple ETL Package Tutorial.

To create a package configuration

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. In SSIS Designer, click the Control Flow, Data Flow, Event Handler, or Package Explorer tab.

  4. On the SSIS menu, click Package Configurations.

  5. In the Package Configuration Organizer dialog box, select Enable package configurations, and then click Add.

  6. On the welcome page of the Package Configuration Wizard page, click Next.

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

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

  9. On the Completing the Wizard page, type the name of the configuration, and then click Finish.

  10. View the configuration in the Package Configuration Organizer dialog box.

  11. Click Close.

See Also

Tasks

Creating Package Configurations
How to: Use Values of Parent Variables in Child Packages

Concepts

Package Configurations

Other Resources

Deployment How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance