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

• Next in forum: Re: Import flat file into SQL Server 2005 Express
• Prev in forum: Re: INNER JOIN/Index Threshold?
• Thread view: Re: BCP import with Blank lines in text file

[Reply to this message]