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 |
|
Rach2009
Starting Member
37 Posts |
 Posted - 2009-11-20 : 05:41:06
|
Hi All,I am trying to do a Bulk Insert using a format file I have created but keep getting the following error message back when I try and execute it in SQL;-Msg 4832, Level 16, State 1, Line 1Bulk load: An unexpected end of file was encountered in the data file.Msg 7301, Level 16, State 2, Line 1Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".[/i]The file I am trying to Bulk Insert is a csv file with 7 columns. Is this likely to be a problem with field/row terminators? The field terminator for the last column in the fmt file is "\"\n" and for all other files just "\"". Also, the last column in the csv file doesn't have data in it for every row, including the very last row, so could this be affecting the Bulk Insert and field/row terminators?Any suggestions why I am getting error message Msg 7301 would also be v useful.Many Thanks!Rachel  |
|
|
|
|
|
Format file - error message