Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dannette
Starting Member
6 Posts |
 Posted - 2008-09-24 : 10:45:21
|
| I hope this is the right place for this question:I'm trying to load 121,000 records using a bulk insert and getting an error "Bulk insert failed due to a schema change of the target table." Nothing in the table changes. The Great Google has very few hits for this error and no solutions, at least not that I've been able to find. As usual, I can't find what I'm looking for in Microsoft's help.I had this error with another table (~60,000 records) and it was fixed by upping the batch size past the number of records. Unfortunately, when I do that with the 121,000 record bulk insert, it takes forever -- I cancelled it at an hour and a half yesterday, when it should only take a few minutes at most.Anybody know what causes this error? |
|
|
|
|
|
Bulk Insert failed: schema change of target table