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:



Leave a Reply 12

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


Koala

Koala

XML

dennis

dennis

why not sql server table?

wieslaw

wieslaw

SQL Server

sql ninja

sql ninja

XML file

SQLdba

SQLdba

XML configuration file

Faisal

Faisal

SQL Server table satisfies both requirements of the question, i.e.:
1. Include multiple properties in a configuration.
2. Support several packages with different configuration settings.
Although you can use XML to save configuration for multiple packages but good practice would be to have separate config files for each package or project. If you want to use a single place to store multiple packages configurations, I would choose SQL Server table.

Slazenjer_m

Slazenjer_m

XML configuration files are not secured; they can be opened and read with any text editor. The answer is SQL Server table… meets all requirements PLUS controlled access to the configuration details.

Jeff_Yen

Jeff_Yen

The answer is “SQL Server”