Command Line from VBScript -- sql server dts

Zibby
10/30/2003 12:48:30 PM

In a bit of a n00b jam. I need to get 5 variables from an html document
to a text file.

The variables come in through VBScript, and are then handed over to
JavaScript for some processing (I can't change the processing). Since
JavaScript won't output to the file, I'll probably have to hand the
variables back over to VBScipt before I can output them.

I have written a batch file that can be run and passed some variables
(test.bat var1 var2 var3, etc), and it will write them to a text file.

Can someone help me on this? Can VBScript either 1) output my 5
variables to a text file directly, or 2) run the batch file at the
command line and follow it up with the variables?

Please help!

--

Allan Mitchell
10/30/2003 6:32:56 PM

Yes and Yes

For the batch file look at the ExecuteProcess task.

Writing to a file you can use the FileSystemObject object

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server dts : Command Line from VBScript