| 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.
  Navigation: [Reply to this message] |