How to write to a text file from stored procedure

Question

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

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

You have not really given a great descrioption of what you are trying to do. If you are more specific, you may get better results.

Given you are using SQL 2005, I would suggest using a CLR stored procedure if you need SQL Server to write to the file system.

Vijaya Kadiyala SSCrazy Eights Points: 9149 More actions · Answer 2

Hi

You should provide more description on your questions so that we can answer in better way.

if you are looking for something to modify the textfiles using T-SQL then check out the below link

Thanks -- Vj

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Peter E. Kierstead SSCarpal Tunnel Points: 4114 More actions · Answer 3

Use sp_OAxxx and COM object "Scripting.FileSystemObject":)

PeteK
I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.