ThomasRushton (8/17/2012)
Are there any locks in evidence on the source or destination tables?It might be worth trying to reduce the transaction batch size - the number of updates / inserts that are queued before being commited.
source and destination is same table...
there are no locks....
Thanks,
Charmer