SQL Server Performance

Skip (only 1) DTS step depending on GlobalVariable

Discussion in 'SQL Server DTS-Related Questions' started by bnaude, Dec 6, 2005.

  1. bnaude New Member

    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

Share This Page