xp_cmdshell - How can I run multiple CMD commands with one script?

[bmacbmac]

Hello,

I am trying to use xm_cmdshell to create and populate a .txt file with the following data:
username
password
cd notindexed
put date.zip
bye

I can add multiple rows to my text file with the following:
<code>
exec master..xp_cmdshell '>c:\temp\ft.txt echo username'
exec master..xp_cmdshell '>>c:\temp\ft.txt echo password'
exec master..xp_cmdshell '>>c:\temp\ft.txt echo cd notindexed'
exec master..xp_cmdshell '>>c:\temp\ft.txt echo put date.zip'
exec master..xp_cmdshell '>>c:\temp\ft.txt echo bye'
</code>

However, is there a way I ran run it as one single script? I tried:
<code>
exec master..xp_cmdshell '>c:\temp\ft.txt echo username'
>>c:\temp\ft.txt echo password
>>c:\temp\ft.txt echo cd notindexed
>>c:\temp\ft.txt echo put date.zip
>>c:\temp\ft.txt echo bye'
</code>

and

<code>
declare @bigscript varchar(500)
set @bigscript =
'>c:\temp\ft.txt echo username'
>>c:\temp\ft.txt echo password'
>>c:\temp\ft.txt echo cd notindexed'
>>c:\temp\ft.txt echo put date.zip'
>>c:\temp\ft.txt echo bye'

print @bigscript
exec master..xp_cmdshell @bigscript
</code>

But both options only create my text file with the first line (uesrname).

This is a small example of a larger portion of my project so I hope there is a way to do this.

Thanks!

 

[markros]

May be you can create a bat file? Also, why do you need to do this from SQL Server?

PluralSight Learning Library

 

[bmacbmac]

I just posted a simple example of a more complex thing I am trying to do. I am actually creating this file from variables in my database so I am hoping to do it through SQL. My existing batch file will then utilize this newly created ft.txt file.

 

[djj55]

Could you use BCP to create the .txt file?

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!