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
Explanation:
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
Project Deployment model -> Environment Variable,
C
0
2
I would think D, as that is the only answer that would allow the job itself to pass in a folder path in a variable.
While it might be possible to have each job set a different environment that has the appropriate value, the question specifically states that the JOB should set the folder path variable not have it set by the environment.
0
0