You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database
into a data warehouse.
The source system contains redundant or inconsistent dat
a. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be
written to a text file for further analysis.
You need to establish the best technique to log these invalid rows while keeping the amount of development effort to
a minimum.
What should you do?
Correct Answer: I
References:
http://technet.microsoft.com/en-us/library/hh230989.aspx
http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html
http://msdn.microsoft.com/en-us/library/ms162820.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
http://technet.microsoft.com/en-us/library/ms140223.aspx
http://msdn.microsoft.com/en-us/library/jj655339.aspx