Export (0) Print
Expand All
1 out of 4 rated this helpful - Rate this topic

Package Configurations Organizer

Updated: 15 September 2007

Use the Package Configurations Organizer dialog box to enable package configurations, view a list of configurations for the current package, and specify the preferred order in which the configurations should be loaded. If multiple configurations update the same property, values from configurations listed lower in the configuration list will replace values from configurations higher in the list. The last value loaded into the property is the value that is used when the package runs. Also, if the package uses a combination of direct configuration such as an XML configuration file and an indirect configuration such as an environment variable, the indirect configuration that points to the location of the direct configuration must be higher in the list.

ms190045.note(en-US,SQL.90).gifNote:
When package configurations load in the preferred order, configurations load from the top of the list shown in the Package Configuration Organizer dialog box to the bottom of the list. However, at run time, package configurations might not load in the preferred order. In particular, Parent Package Configurations load after configurations of other types.

Package configurations update the values of properties of package objects at run time. When a package is loaded, the values from the configurations replace the values that were set when the package was developed. Integration Services supports different configuration types. For example, you can use an XML file that can contain multiple configurations, or an environment variable that contains a single configuration. For more information, see Package Configurations.

Enable package configurations

Select to use configurations with the package.

Configuration Name

View the name of the configuration.

Configuration Type

View the type of the location where configurations are stored.

Configuration String

View the location where the configuration values are stored. The location can be the path of a file, the name of an environment variable, the name of a parent package variable, a registry key, or the name of a SQL Server table.

Target Object

View the name of the object that the configuration updates. If the configuration is an XML configuration file or a SQL Server table, the column is blank because the configuration can include multiple objects.

Target Property

View the name of the property modified by the configuration. This column is blank if the configuration type supports multiple configurations.

Add

Add a configuration by using the Package Configuration Wizard.

Edit

Edit an existing configuration by rerunning the Package Configuration Wizard.

Remove

Select a configuration, and then click Remove.

Arrows

Select a configuration and use the up and down arrows to move it up or down in the list. Configurations are loaded in the sequence in which they appear in the list.

Release History

15 September 2007

New content:
  • Added note about how the package configurations might not load in the preferred order at run time.

14 April 2006

New content:
  • Added information about the order of configurations.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.