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 differentfolder
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.
Parent Package Variable

B.
XML Configuration File

C.
Environment Variable

D.
.dtsConfig file

E.
Registry Entry


Leave a Reply