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