Hi,

I have an Email Task in my DTS package which has a number of 'Failure'
workflows running into it from different parts of my DTS package.

I want the email task to execute if any one of the Failure workflows fires.
I think currently that if you have multiple workflows pointing to a task they
all need to execute for the task to be run(They are 'AND'ed together....) I
need them to be 'OR'ed together instead....

Does anyone know how to achieve this?

Thanks

There are ways and means, such as the following link, but practically the
maintenance overhead is very high for
this method. It would be better to use one mail task per worker task, or use
an external notification, from the calling process, for example setup SQL
Agent Mail if calling the package from a scheduled job.

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

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

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