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


MS Sql Server LazyDBA home page