Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 — Question 18

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 ParamConnection 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 answer presents a part of the solution. Choose all that apply.)

Answer options

• A. Create a package parameter named ConnectionName in each package.
• B. Edit each package Connection Manager. Set the ConnectionName property to @[$Project::ParamConnection].
• C. Edit the project Connection Manager in Solution Explorer. Set the ConnectionName property to @ [$Project::ParamConnection].
• D. Set the Sensitive property of the parameter to True.
• E. Create a project parameter named ConnectionName.
• F. Set the Required property of the parameter to True.

Correct answer: C, E, F

Explanation

The correct answer includes editing the project Connection Manager to use the parameter for connection, creating a project parameter for consistency across packages, and ensuring that the parameter is required. Options A, B, and D introduce unnecessary complexity or are incorrect for the requirement of minimal development effort.