I am wondering if the following scenario is possible in DTS

Task 1
Succeed go to task 2
Fail go to task 3

Task 2
Succeed go to task 4

Task 3
Succeed go to task 4

The problem I have is with task 4 I have 2 precedence constraints (task 2
and task 3) when only one of them is going to run.

Is it possible to set up this type of logic?

Thanks

You can do this, but it is messy. My first suggestion is to try and design
this out of your solution.

A half way house, is to skip tasks. This is quite reliable, and relatively
simple -

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)

For what you originally described, you can really get messy with script as
in this example. It is however a swine to setup and maintain-

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote