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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-17 : 08:20:33
|
| Morten writes "I am using BULK INSERT to put the content of a file into a table.If the file is a binbary file (like a sound file), the process ternminates with the following messages:Server: Msg 4866, Level 17, State 66, Line 1Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.].The statement has been terminated.How can I determine whether a file is binary, so I can skip trying to import it ?Note: filtering files by extention is not an option in my case.I hope there is a solution to this problem.I'm running MS SQL Server Enterprice Edition - 8.00.760 (sp3) onMS Windows Advanced Server 2000 - 5.00.2195 (sp4)RegardsMorten Stenmark" |
|
|
|
|
|
Reading file header