Results 1 to 4 of 4

Thread: Bulk Insert

  1. #1
    Join Date
    Jul 2002
    Location
    Oklahoma
    Posts
    4

    Unanswered: 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.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    1

    Question Re: Bulk Insert

    Hello 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

  3. #3
    Join Date
    Jul 2002
    Location
    Oklahoma
    Posts
    4
    I had a space at the end of the file. You might look and see if you have the same problem.

  4. #4
    Join Date
    Sep 2002
    Location
    Bratislava, Slovakia
    Posts
    1

    Re: Bulk Insert

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •