"OR" workflow dependencies

• joshcsmith13

  Hall of Fame

  Points: 3381

  More actions

  April 3, 2003 at 12:54 pm

  #105902

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

• philcart

  SSC-Forever

  Points: 47794

  More actions

  April 3, 2003 at 4:38 pm

  #453111

  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

• jfb

  SSCrazy

  Points: 2469

  More actions

  April 6, 2003 at 7:03 pm

  #453292

  Hi,

  You can use multiple workflow as this example

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

  JFB