Which three actions should you perform in sequence?

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.)

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

Explanation:
Box 1:

Box 2:

Box 3:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Dude

Dude

-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

From SZ on 70-467 v3

Henrov

Henrov

Well, it kinda depends on whether you use project- or package deployment. To me it is not clear from the question which should be used.