I am using the execute task to invoke a vbscript but I need to be able to specify an input paramenter for the script to process. Without making major changes to the script, how do I specify the extra parameter?

In SQLServer Agent, I would execute "C:\windows\System32\cscript.exe D:\job_executables\MyScript.vbs MyParameter1 MyParameter2 ..."

How do I do this with the execute script or execute task item?

Luther

If you use the Execute Task then:

Command line: C:\windows\System32\cscript.exe
Argument: D:\job_executables\MyScript.vbs MyParameter1 MyParameter2

---

That seems to work. Now I just have to figure out why my script is hanging up or blowing up.

thanks!

Most common reason is that you need a Credential - otherwise it will execute as SYSTEM account and may not have appropriate permissions.

---