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

B.
XML Configuration File

C.
Environment Variable

D.
.dtsConfig file

E.
Registry Entry

2 Comments on “Which package configuration should you use?

  1. Picasso says:

    Can someone explain why this is correct? What confuses me is that the package must be deployed to a single server, does this not make Environment variable incorrect as i thought this implied multiple servers for this to be correct.




    0



    0

Leave a Reply