problem in retriviving data through DTS

[parsql]

Hi all,

I am trying to get data through DTS and after transfering around 651K it gives me Exception Access Violation and it fails to transfer data there is more than millions records in the table!!

what is the solution for this please!!!!

 

[jbenson001]

Are using Access, are you transferring data to, or data from?

 

[parsql]

I am trying to get data out of one sql 2000 server to second one!! using DTS but i get error saying that EXCEPTION_ACCESS_VIOLATION

 

[jbenson001]

ohh i see.. when do you get the error, when you try to run the package or trying to create it?

 

[parsql]

when it runs and after some time it gives me error for Exception_access_violation error and fails to run.

but it does transfers around 650K data out of around 1.5M data