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
1
0
agree +1
0
0
I agree with Matt.
0
0
Thanks Friends
0
0
definitely wrong answer given in the pic, the above comments are correct
0
0
mat is right
0
0
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.
0
0
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.
0
1