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:
1. Deploy the project to the Development and QA Environment.
2. In the deployed package, set the ConnectionString property of the connection Manager to use the ConnectionString Environment Variable.
3. Execute the deployed package by using the required Environment.
IMHO answer should be as follow:
1. Add the Environment references to the deployed project (Deploy not needed, because in question is written that project has been deployed)
2. In the deployed PROJECT….. (all packages in project should be executed with ConnectionString enviorement variable)
3. execute deployed package …
Agree with artur. Seen it elsewhere. You dont deploy things into an environment, you add environment references to a deployed project and then map the variables. This is why the key word environment is just a stupid key word. It could have been configuration like every other software package but they already used that with package deployment
Agree allso with artur.