Post reply

Error while running BULK INSERT

  • June 1, 2006 at 2:58 am

    #68527

    Hi Iam getting this error while running bulk insert statement. Iam trying to insert a file which got data transformed from one of our database table into another table in another database. Please help me out ASAP

    (0 row(s) affected)

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

     

    Location:  record.cpp:897

    Expression:  newColLen >= WideTextPointer:VERHEAD

    SPID:   52

    Process ID:  828

    Connection Broken

  • June 5, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 7, 2006 at 12:06 pm

    #642364

    I don't know if you are having the exact error described in this link (http://support.microsoft.com/?kbid=825197) but take a look.  It states the obvious, install SP 4 blah blah, but also you can try to add DBCC DBREINDEX prior to executing your Bulk Insert Statement, use truncate <tablename> instead of delete from <tablename> etc.

    If this doesn't help, post your statement (and preceding and following lines) that is failing, there be an epiphany from someone once it's viewed.

    Hope this helps

    Jason

    -

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply