Creating Package Configurations
You create package configurations by using the Package Configuration Organizer dialog box and the Package Configuration Wizard. To access these tools, click Package Configurations on the SSIS menu in Business Intelligence Development Studio.
In the Package Configuration Organizer dialog box, you can enable packages to use configurations, add and delete configurations, and set the preferred order in which configurations should be loaded.
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.
From the Package Configuration Organizer dialog box, you run the Package Configuration Wizard, which guides you through the steps to create a configuration. To run the Package Configuration Wizard, add a new configuration in the Package Configurations Organizer dialog box or edit an existing one. On the wizard pages, you choose the configuration type, select whether you want to access the configuration directly or use environment variables, and select the properties to save in the configuration.
If multiple configurations set the same object property, the value loaded last is used at run time.
The following examples show the target properties of a variable and a package as they appear on the Completing the Wizard page of the Package Configuration Wizard.:
\Package\My SQL Task.Variables[User::varTableName].Properties[Value]
The configurations update these properties:
The RaiseChangedEvent property of user-defined variable, TodaysDate.
The MaximumErrorCount, LoggingMode, and LocaleID properties of the package.
The Value property of user-defined variable, varTableName, within scope of the task, My SQL Task.
The "\Package" represents the root, and periods (.) separate the objects that define the path to the property that the configuration updates. The names of variables and properties are enclosed in brackets. The term Package is always used in configuration, regardless of the package name; however, all other objects in the path use their user-defined names.
After the wizard finishes, the new configuration is added to the configuration list in the Package Configuration Organizer dialog box.
The last page in the Package Configuration Wizard, Completing the Wizard, lists the target properties in the configuration. If you want to update properties when you run packages by using the dtexec command prompt utility, you can generate the strings that represent the property paths by running the Package Configuration Wizard and then copy and paste them into the command prompt window for use with the set option of dtexec.
The following table describes the columns in the configuration list in the Package Configuration Organizer dialog box.
The name of the configuration.
The configuration type.
The location of the configuration. The location can be a path, an environment variable, a registry key, a parent package variable name, or a table in a SQL Server database.
The name of the object with a property that has a configuration. If the configuration is an XML configuration file, the column is blank, because the configuration can update multiple objects.
The name of the property. If the configuration writes to an XML configuration file or a SQL Server table, the column is blank, because the configuration can update multiple objects.
To create a Package Configuration
Technical article, Understanding Integration Services Package Configurations, on msdn.microsoft.com
Blog entry, Creating packages in code – Package Configurations, on www.sqlis.com.
Blog entry, API Sample – Programmatically add a configuration file to a package, on blogs.msdn.com.
Tool, Package Configuration File Editor, on codeplex.com.