Bulk insert error

• SEAH SZE YIN

  Old Hand

  Points: 370

  More actions

  February 28, 2008 at 3:10 am

  #203685

  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.

• Vivien Xing

  SSChampion

  Points: 12297

  More actions

  February 28, 2008 at 9:09 pm

  #783581

  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.