Exam4Training

What should you do?

You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amount of administrative effort.

What should you do?
A . Create an On Error event handler.
B . Add a data tap on the output of a component in the package data flow.
C . Use the gacutil command.
D . Create a reusable custom logging component.
E . Run the package by using the dtexecui.exe utility and the SQL Log provider.
F . Run the package by using the dtexec /rep /conn command.
G . Use the Integration Services Deployment Wizard.
H . Run the package by using the dtexec /dumperror /conn command.
. Use the dtutil /copy command.
. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
. Deploy the package by using an msi file.

Answer: G

Exit mobile version