Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Deployment
Package Deployment
 How to: Add a Package Configuration

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
How to: Add a Package Configuration

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

ms140213.note(en-us,SQL.100).gifNote:
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.

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

    ms140213.note(en-us,SQL.100).gifNote:
    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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker