Hi all,

I am simply trying to implement an Execute Process Task
through an ActiveX script. I'm able to control all the
properties, but not the execute method to actually fire
the event. Does anyone have an example of the execute
method with its parameters? See below for the Script I
have.

Thanks in advance,

Mark Frank

Dim pkg, tsk, cus

Set pkg = DTSGlobalVariables.Parent

If DTSGlobalVariables("Version")
= "CCG_Frcst_Plan_04" Then

Set tsk = pkg.Tasks
("DTSTask_DTSCreateProcessTask_1")
Set cus = tsk.CustomTask
cus.Description = "Retrieve Assets"

cus.ProcessCommandLine= "D:\Assets_Plan.bat"
cus.SuccessReturnCode = 9009
cus.Timeout = 0
cus.TerminateProcessAfterTimeout = False
cus.FailPackageOnTimeout = True
cus.Execute(pkg,,,,)?

Else
msgbox ("nothing")
End if

Main = DTSTaskExecResult_Success
End Function

You wouldn't normally start executing tasks individually from a piece of
Active Script. Workflow would normally handle this

--


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