October 20, 2007 at 9:42 pm
Hi All, Bulk Insert error:
Msg 4892, Level 16, State 1, Line 1
Bulk insert failed due to a schema change of the target table.
I cannot find anything about the error.
Please help, Thanks.
October 20, 2007 at 11:43 pm
Hi All,
Here are some more details.
I am using a lot BULK INSERT because I am working with more than 100, 200 million rows to load many tables. I am using BATCHSIZE=500,000. I did not have any problem processing 7 tables before. I do have problem with my last table reported here.
Analyzing all these 7+1 tables to identify differences I have found a key differences between them. PRIMARY KEY (PK) of my 7 previous tables is composed from a single field except last one. PK of my last table is composed from three fields.
Changing value of BATCHSIZE I have realized it cannot > 10.
BULK INSERT cannot be used with BATCHSIZE > 10 if you have PRIMARY KEY (PK) composed of more than one field!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply