DRAG DROP
You develop a SQL Server Integration Services (SSIS) project named Project1 by using
SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:
Configure Package1 so it can run within either a development environment or a test
environment.
Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
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: See the explanation
-Create a folder in SSIS Catalog
-Deploy the packages by using SSIS project deployment model, In SSMS create an environment in SSIS catalog
-In SSMS map environment variables to project parameters and to package specific parameters
http://www.sqlchick.com/entries/2013/9/15/getting-started-with-parameters-variables-configurations-in.html
https://www.simple-talk.com/sql/ssis/ssis-2012-projects-setup,-project-creation-and-deployment/
create folder, then environments
SZ is right
+1