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'
MAXERRORS = 1,
Please advice, Thank you.