benvegiard
Programmer
Hi all,
I am trying to copy the entire contents of a database from one server (Production) to another (Test) on a regular basis. I have created a DTS package using the Export Data wizard. However, the package fails with "Bulk Copy Execution Failed" Checking out the logs, I found that it was unhappy with a table (DocHdr) that had an image field to store electronic document images. These images, on average, or 600k - 1.1 meg. However, I have 4 rows with a 19.8 meg blob.
The package works if I delselect this table for transfer. I found KBase articles about problems moving an image or text field > 64k under SQL 7. However, I am using Win2k sp2. Does this same problem exist? What is the best way for me to move the data on a regular schedule?
Thanks,
Ben
I am trying to copy the entire contents of a database from one server (Production) to another (Test) on a regular basis. I have created a DTS package using the Export Data wizard. However, the package fails with "Bulk Copy Execution Failed" Checking out the logs, I found that it was unhappy with a table (DocHdr) that had an image field to store electronic document images. These images, on average, or 600k - 1.1 meg. However, I have 4 rows with a 19.8 meg blob.
The package works if I delselect this table for transfer. I found KBase articles about problems moving an image or text field > 64k under SQL 7. However, I am using Win2k sp2. Does this same problem exist? What is the best way for me to move the data on a regular schedule?
Thanks,
Ben
