Export (0) Print
Expand All

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.

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

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

Community Additions

ADD
Show:
© 2014 Microsoft