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/values and ensure that all the properties/values are loaded.
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:
Sql Server also supports multiple configurations
E
XML and SQL server are all correct.
I think SQL server table is a better practice.