DRAG DROP
A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project
Connection Manager to connect to the data warehouse.
The SSIS catalog includes two Environments:
Test
Production
Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each
variable consists of the connection string to the test or production data warehouses.
You need to execute deployed packages by using 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.)

Correct Answer:
Box 1:

Box 2:

Box 3:

Explanation:
We need to add references to the Test and Production environments to the project. Then we can map the variables in
the project to the environment variables defined in the environments.
When you execute a package in a project that references multiple environments (Test and Production in this case), we
can select which environment the package runs under.