PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the custom object is deployed on thetest environment correctly

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 thetest
environment correctly. What should you do?

PrepAway - Latest Free Exam Questions & Answers

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 utilityand the SQL Log provider.
K.
Use the dtutil /copy command.

Explanation:
According to this reference, this answer looks correct.
Reference:
http://msdn.microsoft.com/en-us/library/ms403356.aspx


Leave a Reply