Hello,

In DTS, if you right-click a step, there is a command called "Execute Step".

How do you do the same thing from Active X scripting?

Regards,
Elias

Hello Elias,

Suppose you have two steps(step1 is an ActiveX script and step2 is disabled
by default) :

To execute step2 from step1 ActiveX script , you 'd have:

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()


Dim gvs 'As DTSGlobalVariables
Dim gva 'As DTSGlobalVariable
Dim pkg 'As DTSGlobalVariables.parent
Dim stp 'As Step



Set gvs = DTSGlobalVariables
Set pkg = DTSGlobalVariables.parent

set stp = pkg.Steps("step2")
stp.DisableStep = False
stp.ExecutionStatus = DTSStepExecStat_Waiting
set stp = nothing
Main = DTSTaskExecResult_Success
End Function