Câu 22: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

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.)

1. A. Create a package parameter named ConnectionName in each package.
2. B. Edit each package Connection Manager. Set the ConnectionName property to @[$Project::ParamConnection].
3. C. Edit the project Connection Manager in Solution Explorer. Set the ConnectionName property to @ [$Project::ParamConnection]. — đáp án hiện tại
4. D. Set the Sensitive property of the parameter to True.
5. E. Create a project parameter named ConnectionName. — đáp án hiện tại
6. F. Set the Required property of the parameter to True. — đáp án hiện tại