You need to ensure that the custom object is deployed o…

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in
the project uses a custom task component. You need to ensure that the custom object is deployed on the test
environment correctly. What should you do?

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in
the project uses a custom task component. You need to ensure that the custom object is deployed on the test
environment correctly. What should you do?

A.
Run the package by using the dtexec /rep /conn command.

B.
Create a reusable custom logging component.

C.
Create an OnError event handler.

D.
Use the gacutil command.

E.
Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the
configuration.

F.
Run the package by using the dtexec /dumperror /conn command.

G.
Use the Integration Services Deployment Wizard.

H.
Deploy the package by using an msi file.

I.
Add a data tap on the output of a component in the package data flow.

J.
Run the package by using the dtexecui.exe utility and the SQL Log provider.
K.
Use the dtutil /copy command.

Explanation:
According to this reference, this answer looks correct.

http://msdn.microsoft.com/en-us/library/ms403356.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *