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_DontExecuteTaskor
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
]]>