Help. Serious Problem With Error Redirection

Hi,



I have a flat file source. In the flat file, there are some bad, i.e. incomplete rows.



I set up the flat file error output to send the bad rows to a file destination on both "error" and "truncation".



However, for some reason it's really buggy, and doesn't work correctly.



For example, if my data looks like this:



cat, whiskers, 10 -- good row

dog, spot, 15 -- good row

blah -- bad row

blah blah -- bad row

horse, flicka, 20 -- good row



It correctly sends "blah" & "blah blah" to the error output, but it ALSO sends "horse, flicka, 20" to the error output as well.



This is NOT what I want.



I have this particular scenario 5 times in the data file. And each and every time, it sends the first two bad rows PLUS the following GOOD row to the error output, so basically, I lose 5 good rows in the process.



Aside from writing a script to remove the bad rows, is there an explanation for this strange behavior?



Thanks much