What should you do?

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.

Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes.

You need to establish the best technique to log these invalid rows while minimizing the amount of development effort.

What should you do?
A . Add a data tap on the output of a component in the package data flow.
B . Deploy the package by using an msi file.
C . Run the package by using the dtexecui.exe utility and the SQL Log provider.
D . uses the dtutil /copy command.
E . Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration.
F . Create an OnError event handler.
G . uses the Project Deployment Wizard.
H . Use the gacutil command.
. Create a reusable custom logging component.
. Run the package by using the dtexec /rep /conn command.
. Run the package by using the dtexec /dumperror /conn command.

View Answer

Answer: A

Explanation:

Reference:

http://www.rafael-salas.com/2012/01/s sis-2012-quick-peek-to-data-taps.html

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

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