DTS - Execute Process Task - Passing Parameters

[RitchieBoy]

This is a DTS progamming problem !!! (using an ActiveX Script + AN Execute Process Task within a DTS)

I am trying to create a DTS which accepts dynamic parameters for an Execute Process Task.

Essientially i am running a stored procedure which among other things sets a global variable within a DTS i have created.

Using an ActiveX script in the DTS i want to pass the global variable i have set to the Parameter of the Execute Process Task.

I have found a way of passing a variable to the the commandline e.g


Function Main()
' Declare Variables
Dim oPKG
Dim oTask

' Get Package Object
Set oPKG = DTSGlobalVariables.Parent
' Get Named Task
Set oTask = oPKG.Tasks("DTSTask_DTSCreateProcessTask_1&quot
' Set Task CommandLine to new value
oTask.Properties.Item(ProcessCommandLine).Value = DTSGlobalVariables
("GlobalCommandLine&quot.Value

Set oTask = Nothing
Set oPKG = Nothing

Main = DTSTaskExecResult_Success
End Function("GlobalCommandLine&quot.Value


I have not however found a way of passing a global variable to the parameters of the Execute process task.

If anybody knows of a way to do this i would be very greatful, as i have searched everywhere and cannot find a way of doing this

Cheers
Richard