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.
I.
Create a reusable custom logging component.
J.
Run the package by using the dtexec /rep /conn command.
K.
Run the package by using the dtexec /dumperror /conn command.
Explanation:
Reference:
http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html
http://msdn.microsoft.com/en-us/library/hh230989.aspx
http://msdn.microsoft.com/en-us/library/jj655339.aspx
Very good website you have here but I was wanting to know if you knew of any message boards that cover the same topics discussed in this article? I’d really like to be a part of online community where I can get opinions from other knowledgeable individuals that share the same interest. If you have any suggestions, please let me know. Appreciate it!|