Bulk insert error

  • My server updated from SQL2000 to SQL2005, SP2.

    I found error in bulk insert: -

    "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.".

    I do read a few article saying that after apply SP2 and hotfixes, this error should be fix, but unfortunately, it is not in my case, what should i do to fix it?

    This is my script: -

    BULK INSERT wng01_work..nw_business_person FROM 'g:\SQL\FTP\CDIS_Extractew_worker.dat'

    WITH

    (

    MAXERRORS = 1,

    FORMATFILE ='g:\sql\ftp\cdis_extractew_work.fmt'

    )

    Please advice, Thank you.

  • Your case is SP2, 3042?

    This KB says you may need SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2.

    http://support.microsoft.com/kb/942660

    Or make a test table which has the question column only, bulk insert a couple of rows for that column and see what happens.

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

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