Breaking News
Loading...
22/08/2013

SSIS - find error rows in a large file

One of the common issues with SSIS in a real project is that the incoming files contains error rows, but not all of rows. So clients usually request me to help them find the error rows.

I set up the Data Viewer in Data Flow and based on the errors provided by client, I found the exactly the error rows as the screenshot below.


Here is an example.



0 comments:

Post a Comment

 
Toggle Footer