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?

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



Leave a Reply 3

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


Henry Figgins

Henry Figgins

Parent package variable is for connections a variable between a parent task and the child package task it is calling.

dbo

dbo

so the answer is correct? C. Environment Variable