Reply to Re: BCP import with Blank lines in text file

Your name:

Reply:


Posted by Erland Sommarskog on 01/08/07 22:29

EricR (erucevice@gmail.com) writes:
> 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.

Not that I know how your code is written, but it does sound strange to
me, because as I understand it, you have two line feeds at the end.

> 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.

There is an option -L to specify the last record to bulk-copy, but I would
not expect this to prevent any error since that last record is incomplete.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original 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

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