all groups > sql server dts > july 2006 >
You're in the

sql server dts

group:

Bypassing a step with DTS but allowing the other steps to continue


Bypassing a step with DTS but allowing the other steps to continue rmcompute
7/19/2006 12:42:01 PM
sql server dts:
I set up an activex script to bypass a step under a specific condition:

oPKG.Steps("DTSStep_DTSExecutePackageTask_15").DisableStep = True

Assuming the senario listed below, how can Step 3 run if it depends on Step
2 ONLY when Step 2 is run ?

First Step
Step 1 Always runs

On Success of above step runs:
Step 2 Runs Conditionally if other conditions are met

On Success of above step runs
Step 3 Always runs
RE: Bypassing a step with DTS but allowing the other steps to continue Frans van Bree
7/20/2006 2:29:01 AM
It is possible like this:

Set oStep = oPkg.Steps("<name of step 3")
oStep.ExecutionStatus = DTSStepExecStat_Waiting

E.g. by adding a step 1a that checks your additional conditions and if they
are NOT met:
if not conditions
oPKG.Steps("DTSStep_DTSExecutePackageTask_15").DisableStep = True
Set oStep = oPkg.Steps("<name of step 3")
oStep.ExecutionStatus = DTSStepExecStat_Waiting
end if

AddThis Social Bookmark Button