Microsoft
70-463 · Question #61
70-463 Question #61: Real Exam Question with Answer & Explanation
The correct answer is C: Environment Variable. In the Project Deployment model, SSIS environments and environment variables are the correct mechanism for supplying different runtime parameter values to packages called by separate SQL Server Agent jobs.
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
- AParent Package Variable
- BXML Configuration File
- CEnvironment Variable
- D.dtsConfig file
- ERegistry Entry
Explanation
In the Project Deployment model, SSIS environments and environment variables are the correct mechanism for supplying different runtime parameter values to packages called by separate SQL Server Agent jobs.
Common mistakes.
- A. Parent Package Variable is used to pass values from a parent SSIS package to a child package during package-to-package execution, not from SQL Server Agent jobs.
- B. XML Configuration Files are a legacy Package Deployment model feature and are not used or recognized by the Project Deployment model.
- D. .dtsConfig files are part of the legacy Package Deployment model and are incompatible with the Project Deployment model.
- E. Registry Entry configuration is a legacy Package Deployment model option and is not available when using the Project Deployment model.
Concept tested. SSIS Project Deployment model environment variable for runtime configuration
Community Discussion
No community discussion yet for this question.