You are here: Re: BCP import with Blank lines in text file « MsSQL Server « IT news, forums, messages
Re: BCP import with Blank lines in text file

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация