write cursor output to a file

Question

Post reply

write cursor output to a file

Richard_Hadfield

Ten Centuries

Points: 1113
More actions
June 30, 2004 at 5:42 am

#108620

Is there an easy way to write the output of a cursor to a file from within a stored procedure? Someone suggested using Osql?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

You will have to use sp_OQCreate to open a file system object and write in the data unless you are using DTS.

Wayne-153714 Hall of Fame Points: 3536 More actions · Answer 2

osql -Sserver

-E -ddatabase -Q"EXEC sproc" -o"C:\temp\OSQLOutput.txt"

The file will contain your output. Put the cursor in a stored procedure.

The file will need to be cleaned though, as it will contain row headings.

When in doubt - test, test, test!

Wayne

Richard_Hadfield Ten Centuries Points: 1113 More actions · Answer 3

I actullay just resolved this, I turned to DTS in the end, created an ActiveX task and used ADO and FSO. Out of interest it was to build an HTML file that I used within xp_smtp_sendmail and attach it as a messagefile. Thanks for the pointers