Post reply

DTS Package in SQL 2000. To skip several steps conditionally

  • September 30, 2008 at 7:12 am

    #127817

    Hi,

    In a package consisting of several steps, i want a few steps to be disabled/skipped conditionally. I am trying to do this in an activex like this but the moment it encounters the first step that is disabled, all the other steps too retire:

    SET pkg = DTSGlobalVariables.Parent

    SET AStep = pkg.Steps(DTSStep_DTSDynamicPropertiesTask_1)

    SET BStep = pkg.Steps(DTSStep_DTSActivexTask_1)

    SET CStep =

    SET DStep =

    SET EStep =

    AStep.DisableStep = True

    BStep.DisableStep = False

    CStep.DisableStep = True

    DStep.DisableStep = True

    EStep.DisableStep = False

    There are few more steps that follows. Here the package stops at AStep itself where it encounters a Disable as TRUE. But I want BStep and Estep to run, along with few other steps that follows.

    Any help would be greatly appreciated. Thanks

  • September 30, 2008 at 7:34 am

    #878851

    How are you handling the workflow? If you're using on success You'll never get an on success for a disabled step therefore it won't proceed because the on success criterion.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 1, 2008 at 7:48 pm

    #879791

    I am using an "on completion status" and this does not work out as well.

  • October 2, 2008 at 6:09 am

    #879904

    Right, the step never completes so it can't move to the next even using on completion...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • October 2, 2008 at 10:53 pm

    #880284

    Even i am facing with a similar issue. Any thoughts on how this can be implemented.

  • October 3, 2008 at 6:16 am

    #880416

    you could have a look at the below link and see if it fits the bill...

    http://www.sqldts.com/214.aspx

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply