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:
SQL Server
0
0
XML
0
0
**Include multiple properties in a configuration.
**Support several packages with different configuration settings.
…The above scenario requires SQL Server configuration; the one depicted below requires XML Configuration File:
**Include multiple properties in a configuration.
**Force packages to load all settings in the configuration.
**Support Encrypting File System (EFS) formats.
0
0
could u guys provide some links!?
0
0
This has been tested and it looks only SQL Server Configuration can
1.Include multiple properties in a configuration.
This is selectable feature XML configuration can holds multiple properties as well.
2. Support several packages with different configuration settings.
Configuration for other packages in the project can be saved to the same sql server table with different configuration setting.
This does not work for XML configuration though.
So the answer is SQL Server configuration type.
0
0