PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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

One Comment on “Which package configuration should you use?


Leave a Reply