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.)
Answer: 
Explanation:
Add the Enivronment reference…
In the deployed project…
Execute the deployed package by…
0
0
1. Add the Environment reference to the ‘catalog-deployed’ project
2. In the deployed project, set the ConnectionString property…
3. Deploy the project to test and production environments
…After these, you can execute the package at those sites w/out having to manually edit the connection string for each environment.
0
0
Sorry Guys, after re-reading the question, I realized we are not actually deploying to a LIVE (Test/Production) environment. We are just trying to simulate those environments; so, #3 in my previous post is irrelevant AND should be replaced with ‘Execute the deployed package by using…’
0
0
I can see how cao is right, but what about rights. You need permissions to the environment as a user to execute the project under those environments. Of course, you also need to execute the project to execute the project so cao’s step 3 is right tautologically. Is a tautological answer necessarily an answer? That’s enough metaphysics. This again is a stupid question.
0
0