Which of the five package configuration options are always applied last, regardless of where you place them in the configurations organizer?

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.
Which of the five package configuration options are always applied last, regardless of
where you place them in the configurations organizer?

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.
Which of the five package configuration options are always applied last, regardless of
where you place them in the configurations organizer?

A.
XML Configuration File

B.
Environment Variable

C.
Registry Entry

D.
Parent Package Variable

E.
SQL Server

Explanation:



Leave a Reply 2

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


Łukasz

Łukasz

ok
https://msdn.microsoft.com/en-us/library/cc895212.aspx

“By design, parent package variables are always applied last, regardless of where you place them in the configurations organizer. This is not necessarily a bad thing, but because of this, this type of configuration may not suitable in every scenario.”

Mahmoud Ibrahim

Mahmoud Ibrahim

D