|
|
Posted by Craig Kelly on 10/11/05 01:08
<savvaschr@nodalsoft.com.cy> wrote:
>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???
>
> Thanks a lot
> Savvas
As Erland already pointed out, the most likely culprit is the fact that your
file is from a Unix server. This is definitely the problem if the records
in your file have 22 fields. As far as I can tell, you have 2 options:
1. Do as Erland suggested and "fix" the file before you import it... either
with a text editior or little utility program you write (please see below).
2. See if the code running on the Unix host can be changed to use \r\n
instead of \n.
Craig
Navigation:
[Reply to this message]
|