Hi,

I have created several DTS Tasks that transferring data from 2 DB on the
same server using DataPumps. I have created a job that runs them.
After several runs, when all data is transferred successfully, I run it
again and I get some table with no rows transferred. I get no error and it
marked as "Success" in the Job. This behavior has no rules it can work fine
10 times and then the problem accurse.
I'm working with DTS for 5 years and yet this is the first time I
encountered with such a bizarre problem.

Does anyone know this problem and how it can be solved?

The server is win 2003 Std. with 2 HT CPU's and 4GB RAM. SQL Server 2000 Ent.

Thanks,

Elran.