Try this to write output to text files

😛

Set ANSI_Nulls on

set QUOTED_IDENTIFIER ON

Declare @cmd varchar(1000)

Declare @WorkfileName varchar(128)

Declare @WorkDir varchar(100)

Select @WorkfileName = 'test1.txt'

Select @WorkDir = '\\Phivmfile001\ds\Production\Input\Tests\'

Select @cmd = 'echo ' + 'Print "Hello" ' + ' > ' + @WorkDir + @WorkfileName

exec master..xp_cmdshell @cmd, no_output

Select @cmd = 'echo ' + 'Print "Hello" ' + ' >> ' + @WorkDir + @WorkfileName

exec master..xp_cmdshell @cmd, no_output