Many thanks for the tip, I used the following:

xp_cmdshell 'echo Hello World > c:\Filename1.txt' ----to create file

xp_cmdshell 'echo Hello Again > c:\Filename2.txt' ----to create file

xp_cmdshell 'copy /B c:\Filename1.txt + c:\Filename2.txt...