Saturday, February 25, 2012

Bulk Insert

Hi everyone
I am trying to insert a file into a table. The error I am getting is:
Server: Msg 3624, Level 20, State 1, Line 1

Location: record.cpp:816
Expression: newColLen >= WideTextPointer::OVERHEAD
Can anyone help with this problem.
ThanksHello cney,

i have the same problem. Do you have solved this problem in the meantime? Which command do you have used to get this error ('bulk insert' or 'bcp' or something else)?

Thank you for any answer,

SoftProg

Originally posted by cney
Hi everyone

I am trying to insert a file into a table. The error I am getting is:

Server: Msg 3624, Level 20, State 1, Line 1

Location: record.cpp:816
Expression: newColLen >= WideTextPointer::OVERHEAD

Can anyone help with this problem.

Thanks|||I had a space at the end of the file. You might look and see if you have the same problem.|||Hi there,
I've got exactly the same error 3624 using BULK INSERT into a table with text column when there were no data in the BCP file for the text-typed column (at least in one row). A single space in the BCP file solved the problem.

Hope this helps,

Palo

No comments:

Post a Comment