|
|
Posted by Erland Sommarskog on 10/10/05 10:20
(savvaschr@nodalsoft.com.cy) writes:
> i Use the above and i got an error
>
> Server: Msg 4866, Level 17, State 66, Line 1
> Bulk Insert fails. Column is too long in the data file for row 1,
> column 22. Make sure the field terminator and row terminator are
> specified correctly.
> 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.
> The statement has been terminated.
>
>
> I am openign a unix file and read from it ...is there a chance that the
> '\n' is not the RowTerminator ??? What posible character except '\n'
> might be???
\n as terminator has always been problematic, because \n in the format
specification is interpreted as \r\n. I can't recall that I have ever
been able to get it to work.
A work around is to open the file from Windows with an editor, and make
sure that when you save again that lines are terminated with \r\n.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|