OK cheers.....

I'm already investigating the OSQL route...so I'll add your suggestion to the mix.

Thanks.

Bob Berry:cool:

Good morning all....

Hammer and chisell......I ask you......its a nice funny way to sart the week...thanks 🙂

The sql is run by me running a sql 2005 automated job through Sql server...

i tried that it puts a SQLSTATE 0100 on the of each print line...

i'll the the osql route

thanks any way.

The output is created by a series of select statements, as sample is shown bellow:

--Output Report Master Header

set @output = 'Weekly Stock Report - Year '+ @yearcode + ' Period...

Its part of a scheduled job, that runs overnight and outputs to a text file...which then gets picked up by another package and sent out to remote locations as a...