Which package configuration should you use?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure.

The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model.

Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package.

You need to configure the package to accept the folder path from each job.

Which package configuration should you use?
A . .dtsConfig file
B . Registry Entry
C . Environment Variable
D . Parent Package Variable
E . XML Configuration File

View Answer

Answer: C

Explanation:

Reference:

http://msdn.microsoft.com/en-us/library/ms345179.aspx

http://msdn.microsoft.com/en-us/library/ms141708 .aspx

http://msdn.microsoft.com/en-us/library/hh213214 .aspx

http://msdn.microsoft.com/en-us/library/hh213296.aspx

http://msdn.microsoft.com/en-us/library/ hh213293.aspx