PrepAway - Latest Free Exam Questions & Answers

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.

PrepAway - Latest Free Exam Questions & Answers

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.
Reference: Package Configurations

5 Comments on “Which configuration type should you use?


Leave a Reply