Can you post the code in the SP, as that might help us see what's going on.

I take it you've don't a count on the source table and that matches the number of rows in the text file.