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



Leave a Reply 5

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


Wibble

Wibble

Why is SQL Severs the only correct answer?

Alex

Alex

I think this is the only solution that supports multiple package configuration

Mahmoud Ibrahim

Mahmoud Ibrahim

SQL Severs Correct

ramushasha

ramushasha

xml can also be a correct answer