rockstar283 (10/22/2013)
Data viewer on the Green pipeline is showing me all the records before that particular erroneous record
Sure? It might also show all the records loaded into the first buffer loaded when the error occurs.
SSIS doesn't load data row by row.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP