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:
XML Configuration file
XML Configuration File:
**Include multiple properties in a configuration.
**Force packages to load all settings in the configuration.
**Support Encrypting File System (EFS) formats.
SQL Server configuration:
**Include multiple properties in a configuration.
**Support several packages with different configuration settings.