I have two SQL 2005 Servers which are located on separate computers with MS
Windows Server 2003. Those computers have connection through VPN. Both
instances have the same db. Since I developed DTS long time ago when we had
MS SQL 2000 I have that DTS set as a job in SQL 2005. That DTS just transfers
about 75000; however, it was working only when we have about 35000 records.
If we have more DTS fails and the log shows that DTS transfered 35000 (that
varies) and due to disconnection (looks like servers stops seeing each
others) between servers everything rolls back. Any advices? Thanks.