I am moving data out of a table using BCP to a file and then loading it back into a different table using BCP. I am moving about 5 million to 10 million per call. The data gets to the file quick enough (5-10 mins). The problem is with the load. It loads about 95 percent of the data, then it hangs. I am watching how many rows go into the table by the looking at the results text file. It takes about 25 mins to get 95% inserted then it hangs for about 2-3 hours until it finally completes. Disk i/o is low during this time. Anyone know what is going on?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Bulk insert hangs at end of inserting (BCP)
- Thread starter vnad
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question