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:
The answer is wrong:
https://msdn.microsoft.com/en-us/library/hh213290.aspx
Legacy Package Deployment Model deploys to msdb. So there will be no SSIS catalog or environment variable to be created…
0
0
The answer is:
Create a folder in SSIS catalog.
deploy in project mode.Create environments.
map environments.
0
0
Dim, I agree with you
0
0
Agree
0
0