Yes, that is how it should work if the error handling is configured that way.

Row(s) are probably being missed.

Direct the error output to a flat file to see the rows causing the error. (Unless you have done that already)

Norman

DTS Package Search

http://www.dtspackagesearch.com/