Microsoft
70-458 · Question #138
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. All packages in the project must connect to the same database…
The correct answer is B. Edit each package Connection Manager. D. Create a project parameter named ServerName. F. Set the Required property of the parameter to True. See the full explanation below for the reasoning.
Question
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. All packages in the project must connect to the same database. The server name for the database must be set by using a parameter named ServerParam when any package in the project is executed. You need to develop this project with the least amount of development effort. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
Options
- ASet the Sensitive property of the parameter to True.
- BEdit each package Connection Manager.
- CEdit the project Connection Manager in Solution Explorer.
- DCreate a project parameter named ServerName.
- ECreate a package parameter named ServerName in each package.
- FSet the Required property of the parameter to True.
How the community answered
(42 responses)- A5% (2)
- B71% (30)
- C7% (3)
- E17% (7)
Community Discussion
No community discussion yet for this question.