A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project
includes a project Connection Manager to connect tothe data warehouse. The SSIS catalog includes
two Environments:
Development
QA
Each Environment defines a single Environment Variable named ConnectionString of type string. The
value of each variable consists of the connection string to the development or QA data warehouses.
You need to be able to execute deployed packages byusing either of the defined Environments.
Which three actions should you perform in sequence?(To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)
Answer:
Explanation:
I thnik it should be:
1. Add the Environment reference to the deployed project
2. In the deployed project, set the ConnectionString property of the Connection Manager to use the ConnectionString Environment Variable
3. Execute the deployed package by using the required Environment
agree +1
I agree with Matt.
Thanks Friends
definitely wrong answer given in the pic, the above comments are correct
mat is right
Agreed with Matt, as the original is definitely wrong – you cannot deploy project to QA and Development environments are there to hold variable values and permissions for the project.
the answer should be:-
#Deploy the project to the development and QA environment.
#In the deployed project, set the connection string of the connection manager to use the ConnectionString Environment Variable.
#Execute the deployed package by using the required environment.