DRAG DROP
You install SQL Server Integration Services (SSIS) and develop an SSIS project to load a
data warehouse. The project defines 10 parameters that have different values for the
development, test and production environments. Some packages have additional
parameters defined.
You plan to deploy the SSIS packages to one server. The server will also host the
production data warehouse.
You need to deploy and configure the packages.
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:
-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
0
0
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.
0
0