I set up an activex script to bypass a step under a specific condition:

oPKG.Steps("DTSStep_DTSExecutePackageTask_15").Dis ableStep = 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

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").Dis ableStep = True
Set oStep = oPkg.Steps("<name of step 3")
oStep.ExecutionStatus = DTSStepExecStat_Waiting
end if

Cannot test it here, but it should work.