You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSIS01 runs SQL Server 2012 Integration
Services (SSIS).
You need to determine which package configuration to use for SSIS packages. You need
to select a package configuration option that will allow you to store multiple configuration
properties and values and will enable multiple packages to use the configuration.
Which of the five package configuration options should you use?
A.
XML Configuration File
B.
Environment Variable
C.
Registry Entry
D.
Parent Package Variable
E.
SQL Server
Explanation:
E Correct