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 Project Deployment Wizard.
H.
Run the package by using the dtexec /dumperror /conn command.
I.
Use the dtutil /copy command.
J.
Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store
the configuration.
K Deploy the package by using an msi file.
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/hh479588.aspx
http://msdn.microsoft.com/en-us/library/hh213290.aspx
http://msdn.microsoft.com/en-us/library/hh213373.aspx