Hello, I have a SQL Table, into which I am attempting to do a Bulk Insert With FormatFile. I have SQL Server 2005, and a hyperterminal output from our phone system (PartnerMail). I can't seem to get this to work ... Not Sure how to deal with
the "Sometimes-there's-a-Double" time at the end ... And not sure of the 'MaxBytes' value (the second zero) ...
I keep getting one of two error messages, depending on what I mess with:
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".