You need to ensure that the project is deployed to the …

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?

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.

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:
According to these references, this answer looks correct.

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



Leave a Reply 1

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