"OR" workflow dependencies

  • so, I want one task to happen if any one of ten other tasks fail. how do set that up in the DTS designer?

  • Doing it via the workflow, there is no "OR" in DTS.

    You'll have to have an "On Failure" branch with the task you want to execute for each of the ten other tasks.

    There are other methods you could look at but they will still require an individual "On Failure" task for each of your tasks.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • Hi,

    You can use multiple workflow as this example

    http://www.sqldts.com/default.aspx?6,103,218,7,0

    JFB

Viewing 3 posts - 1 through 2 (of 2 total)

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