Posted by EricR on 01/08/07 14:45

> Since I don't know Java, I need to ask a really stupid question: do
> you really need that extra \r\n at the end? Can't you prevent Java
> from adding it? Because, it can be quite difficult to get BCP to handle
> that file. BCP believes in complete records so to speak.

I can stop it from adding the new line character in Java but that is
easier said than done considering how my code is written. i have no way
of knowing how many records are going to be written to the text file
before the file is written. That is why I was hoping that there may be
some way within bcp to get it to ignore the last line, but the more I
play around with it the more I see that this is probably not possible.
Thanks for your suggestions.

[Back to original message]