PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the project is deployed to the production environment with the least amount of adminis

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?

PrepAway - Latest Free Exam Questions & Answers

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:

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

One Comment on “You need to ensure that the project is deployed to the production environment with the least amount of adminis


Leave a Reply