Never mind - that doesn't do it either... it was just a thought, sorry.

-----Original Message-----
From: Trevor Weir
[mailto:mssqldba-ezmlmshield-x32648307.[Email address protected]
Sent: Thursday, April 28, 2005 7:26 PM
To: LazyDBA Discussion
Subject: RE: DTS Packages & Workflow

Have you tried changing

step 3 -> step 4 on success

to

step 3 -> step 4 on "completion"

?

Trevor
-----Original Message-----
From: Juan Vera
[mailto:mssqldba-ezmlmshield-x14922405.[Email address protected]
Sent: Thursday, April 28, 2005 3:52 PM
To: LazyDBA Discussion
Subject: DTS Packages & Workflow

I am writing some workflow logic into a DTS package and am frustrated by a
problem:



If I want:

step 1 -> step 2 on success

step 1 -> step 3 on failure

step 2 -> step 4 on success

step 3 -> step 4 on success



but I <know> steps 2 & 3 never run on the same execution, since 3 is an
alternative to recover in case of a failure in 2, I need the DTS to
understand a logical OR, i.e. run step 4 if either 2 or 3 succeed. However,
there seems to be no logical OR available for aggregating workflow
conditions in the DTS, so the "recommendation" is to copy/paste step 4 !?!?!
- Now, this stinks because obviously if the job has several steps then the
number of copies grows rapidly, and as database people I don't think I need
to explain to this group how all errors start from information duplication /
denormalization, never more so than in processes...



does anyone know how to get the DTS to do a logical OR, so I can avoid
having to copy & paste the entire logic tree following from step 4 in this
scenario?



TIA



Juan Cristian



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page