Hi,

I have a SQL Task, that has two seperate "On Success" Workflows coming from
it.

I want to know if there is a way of setting my first "On Success" workflow
to have priority over the second workflow. i.e. So One task runs before the
other...

I've looked at the RelativePriority Property however it doesn't seem to work
as I expected?

Thanks for helping


Jon Derbyshire

Hello Jon,


Why not then just have the "2nd priority" task go after the "First Priority"
task?

Would that solve things?



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan,

Unfortunately this wouldn't work as required.

I need to be able to predefine the required path prior to execution of the
DTS.

Example:

Imagine I have an Analysis Services Processing Task with an "On Completion"
workflow, an "On Failure" workflow, and an "On Success" workflow.

The On success will simply execute an SQL Task to report success to a Log
Table.

The On failure will execute an SQL Task to report Failure to a Log Table.

The On Completion will continue onto the next AS Processing Task.

In this scenario I would like either the "On sucess" OR the "On Failure" to
be executed BEFORE the "On completion" Workflow.

Any Ideas?

Jon Derbyshire

"Allan Mitchell" wrote:

Hello Jon,



OK we can do that as well. You need a logical OR to the On Completion Step.
So you would have 3 paths flowing to the On Completion Step. One of them
is the default path and the other two are the ones after handling the "On
Success" OR the "On Error"


Have a look here

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


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks for your help Allan

Much appreciated

Jon

"Allan Mitchell" wrote: