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.
Force packages to load all settings in the configuration.
Support Encrypting File System (EFS) formats.
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:
I wouldn’t place my Connection Strings/settings into an XML Configuration File, because the sensitive information needs to be encrypted, and this is not feasible with an XML file.
By using SQL Server as the configuration file, all the configuration items are stored in SQL Server tables and could be secured either at the solution or package level, by controlling object access (with userkey, password, etc).
0
0
Maybe you are right. But still the correct answer is XML file. In fact what do you mean with “…using SQL Server as the configuration file…”
0
0