Posted by Rod on 07/09/07 19:01

> Any particular reason you are using ISQL? You may have better luck with
> OSQL. Or maybe even better luck with BCP.
>

OSQL (as ISQL) breaks the output into lines of fixed length, this
brings some
issues as we are handling xml data (invalid elements are reported when
they reach
the end-of-line) .

BCP seems the way to go as it's not truncating the output and writes
without a prob
upto 100k chars per line (tested). Now, something that surfaced after
some testing to
implement BCP usage, is that BCP only writes to text file the very
first "select" statement
of the several that conform my stored procedure, will need to find a
workaround.

Thanks

• Next in forum: Re: ISQL is truncating contents of text field sent to text file.
• Prev in forum: Re: Define a Key - "select * from "
• Thread view: Re: ISQL is truncating contents of text field sent to text file.

[Reply to this message]