I have created a bat file that I use to start several scripts and sqlcmd commands, something like this:
sqlcmd -S SERV2K3STD\SQLEXPRESS -i C:\MyTests\FS\Scripts\sql_statement_01.sql
bcp [Mondial_LAM].[dbo].[FileTest] in C:\MyTests\FS\Scripts\some_file.txt -S SERV2K3STD\SQLEXPRESS -c -T
sqlcmd -S SERV2K3STD\SQLEXPRESS -i C:\MyTests\FS\Scripts\3sql_statement_02.sql
My question is how to create a WSH / vb script instead of bat file that would launch those files as a scheduled task. I mean, how do I create such vbs file to be able then launch it through Scheduled tasks?