Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crystal_szeyin
Starting Member
9 Posts |
 Posted - 2008-02-28 : 05:12:22
|
| 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 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-28 : 05:22:41
|
| Silly question, but have you checked the file and made sure that the column isn't too wide to fit into your field? |
 |
|
|
crystal_szeyin
Starting Member
9 Posts |
Posted - 2008-02-28 : 09:44:36
|
| Anyone outhere can help?Table structure is exactly the same as defined in the file format. The data in the data file is not longer than the length defined.The same data file works fine in SQL2000 but not in SQL2005.PLEASE ADVICE |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-01 : 21:45:00
|
| Did you specify correct column delimiter? |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-03-02 : 14:19:40
|
| whats the length of the first column in your dat file ?Although,I don't think thats the problem cos bcp would simply truncate the extra length and insert.Check if you have the right row and column delimter specified.Theres a difference between CR and CRLF as row delimiter.You can get that error possibly cos you might have CRLF as delimter in your dat file and CR specified in format file or vice versa. |
|
|
|
|
|
|
Bulk insert error