What should you do?

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.)
A. Set the Sensitive property of the parameter to True.
B. Edit each package Connection Manager. Set the ServerName property to @[$Project::ServerParam].
C. Edit the project Connection Manager in Solution Explorer. Set the ServerName property to @[$Project::ServerParam].
D. Create a project parameter named ServerName.
E. Create a package parameter named ServerName in each package.
F. Set the Required property of the parameter to True.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.