• 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