You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific data
originating from a SQL Azure database, a custom task component is added to the project. You need to ensure
that the custom component is deployed on a test environment correctly. What should you do?
A.
Add an OnError event handler to the SSIS project.
B.
Use an msi file to deploy the package on the server.
C.
Open a command prompt and run the gacutil command.
D.
Open a command prompt and run the dtutil /copy command.
E.
Open a command prompt and run the dtexec /rep /conncommand.
F.
Open a command prompt and run the dtexec /dumperror/conn command.
G.
Run the package by using the dtexecui.exe utilityand the SQL Log provider.
H.
Create a reusable custom logging component and use it in the SSIS project.
I.
Configure the SSIS solution to use the Project Deployment Model.
J.
Configure the output of a component in the package data flow to use a data tap.
K.
Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL
Server.
Explanation:
According to this reference, this answer looks correct.
Reference:
http://msdn.microsoft.com/en-us/library/ms403356.aspx