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.
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.

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:



Leave a Reply 4

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


Panos

Panos

SQL Server. XML doesn’t support encryption

Panos

Panos

Changed my mind. I will go with the answer – XML configuration file
I think the EFS line is there to tell you that you need to use the file system

henrov

henrov

Panos is ultimately right: it should be XML

CorvusAlpha

CorvusAlpha

XML configuration