Which configuration type should you use?

HOTSPOT
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.
Support several packages with different configuration settings.
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.

HOTSPOT
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.
Support several packages with different configuration settings.
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.

Answer:

Explanation:
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.

Package Configurations



Leave a Reply 0

Your email address will not be published. Required fields are marked *