Skip (only 1) DTS step depending on GlobalVariable | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Skip (only 1) DTS step depending on GlobalVariable

Hi I want to skip or execute the first step of my DTS package depending on a global variable, so I added an ActiveXScript to its workflow property, setting Main = DTSStepScriptResult_DontExecuteTask
or
Main = DTSStepScriptResult_ExecuteTask depending on the value of the GlobalVariable. The problem is that, if this package does not execute (based on Main = DTSStepScriptResult_DontExecuteTask) then ALL subsequent packages skip execution too. How do I skip one step, but execute all subsequent steps? Many thanks
Bennie
Sydney
]]>