DTS package finishing too early

[Katy44]

I hope someone can help me.
I have a DTS package which copies data between tables on the same db.
The source is a query, which formats things and moves things around. It's in the form of "select ..from <table1>" - no where clause. <table1> has 1.8 million rows. The destination is an empty table. Transformations are normal, and I've set it up to error a max of 9999 times before it fails, and output to an error log. Fast load is off.
The server has a query timeout of zero (i.e. unlimited).
Whenever I run this package it only seems to process 4902 rows, and then it says it has completed successfully. When I look in the destination table, it has 4890 rows, and I'd be OK if 12 were failing out of this lot. But why is it stopping?

 

[dbomrrsm]

can you post the exact query ?

[blue]DBomrrsm[/blue]

 

[Katy44]

No, there are 200+ columns!

I've finally got it working thanks, I think the setup I needed in the end was 'fast load' on and commit >0.