You need to ensure that package logging occurs

You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On
several occasions, the package execution does not finish and no data seems to have been
transferred.
You need to ensure that package logging occurs. Your solution must minimize deployment
and development efforts.
What should you do?

You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On
several occasions, the package execution does not finish and no data seems to have been
transferred.
You need to ensure that package logging occurs. Your solution must minimize deployment
and development efforts.
What should you do?

A.
Run the dtutil command to deploy the package to the SSIS catalog and store the
configuration in SQL Server.

B.
Use an msi file to deploy the package on the server.

C.
Open a command prompt and execute the package by using the SQL Log provider and
running the dtexecui.exe uti

D.
Create a reusable custom logging component and use it in the SSIS project.

E.
Open a command prompt and run the dtutil /copy command.

F.
Configure the SSIS solution to use the Project Deployment Model.

G.
Add an OnError event handler to the SSIS project.

H.
Open a command prompt and run the gacutil command.

I.
Open a command prompt and run the dtexec /dumperror /conn command.

J.
Open a command prompt and run the dtexec /rep /conn command.
K.
Configure the output of a component in the package data flow to use a data tap.

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141212.aspx
http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-
2012-part-1 -of-2/
http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-
2012-part-2-of-2/



Leave a Reply 12

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


Marge

Marge

existing package – no mention of a project!

Modi

Modi

the answer is C and it is the same Question Number 55

sql ninja

sql ninja

i would say C too. i think SQL Log provider is the key word

Iheb

Iheb

why G is not correct??

Łukasz Sawa

Łukasz Sawa

I think G is not correct beacuse is “Your solution must minimize deployment
and development efforts.” – and adding Event handler is still some kind of Development. I think C is the best.