Microsoft
70-458 · Question #28
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…
The correct answer is C. Environment Variable. See the full explanation below for the reasoning.
Question
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?
Options
- A.dtsConfig file
- BRegistry Entry
- CEnvironment Variable
- DParent Package Variable
- EXML Configuration File
How the community answered
(57 responses)- A5% (3)
- B4% (2)
- C77% (44)
- D12% (7)
- E2% (1)
Community Discussion
No community discussion yet for this question.