You are designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Force packages to load all settings in the configuration.
Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.
Hot Area:
Correct Answer:
Explanation/Reference:
Note:
Package Configuration Types
The following table describes the package configuration types.
* SQL Server table
A table in a SQL Server database contains the configuration. The table can include multiple configurations.
* XML configuration file
An XML file contains the configurations. The XML file can include multiple configurations.
* Environment variable
An environment variable contains the configuration.
* Registry entry
A Registry entry contains the configuration.
* Parent package variable
A variable in the package contains the configuration. This configuration type is typically used to update properties in child packages.
Reference: Package Configurations
