August 9, 2006 at 7:39 am
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!!!!
August 10, 2006 at 6:24 am
Since you are transferring more than 1 million records, why not use BCP? It'll be much faster than DTS, and you can break up the batches into smaller segments and perhaps have better control over the transfer.
August 15, 2006 at 8:18 am
In the past, when faced with this problem, I "chunked" the ttransmission. I wrote a front end procedure that first populated a small table consisting of key ranges only. The procedure received a parameter stating the number of rows in each chunk. Then I wrote another procedure that called a DTS package to read the table, transmit one chunk and log the result. The procedure first read the log and transmitted the next chunk iof there was one. If the log was empty for the transmission, it transmitted the first chunk. In this manner, the transmission could be restarted at any time and at any place. It took a few days to put all this together, but it worked fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply