bulk load rowdelimiter error - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

bulk load rowdelimiter error

Author

Topic

dainova
Starting Member

31 Posts

Posted - 2009-07-28 : 16:52:50

Hi, all
I'm using BULK INSERT from file into table and have this error:


BULK INSERT rtsidref
  FROM 'f:\ctlg\rts3.rpt' WITH 
 ( FIELDTERMINATOR = '\t,', rOWTERMINATOR = '\n' )

Server: Msg 4832, Level 16, State 1, Line 1
Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.
Server: Msg 7399, Level 16, State 1, Line 1
OLE 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.

input file is the result of sql select with tab-delim into file.

I see in hex editor that my FIELDELIMITER = X'09' and ROWDELIMITER=X'0D' + x'0A' (Yes!! it takes 2 squares in hex-editor) (0D=Carrage return=.., 0A=new line='\n')
anybody know how to contatenate those chars for ROWDELIMITER paramater to make it work?

I think I did it before a week or so ago with the same sql and input file and it worked, but now it doesn't.

Tx
dai

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-28 : 17:39:04

Have you tried

( FIELDTERMINATOR = '\t', ROWTERMINATOR = '\r\n' )

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources