I had a somewhat related question.

I want to use a SQL command to write a string to a text file using Master...xp_cmdshell.

essentially clobbering the contents.