How can I make this work?
I have two process steps in a package and one failure step. Both process steps have On Failure workflows to the failure step. The problem I'm having is that it seems if two or more workflows go to the same failure step then neither go to the failure step, but it does go if only one process step is attached to it.
I know I can create duplicate steps for each process step, but I was hoping to be able to do it this way FMI.
Thanks for your assistance.Has anyone tried what I am talking about on their end? I'd really like to know if it's just a problem I'm having.
Subscribe to:
Post Comments (Atom)
1 comment:
Hi confl! Just wanted to shed a little light on this one for any poor sobs that have to work with DTS's. The short answer is, you can not have a single On Failure step for multiple process steps.
This page on MSDN finally helped me understand why:
http://msdn.microsoft.com/en-us/library/aa933535%28v=sql.80%29.aspx
...way down at the bottom, it mentions that the DTS assumes a logical "AND" relationship when "Using Multiple Precedence Constraints" as they call it. In a nutshell, if you had Step A and Step B set up with On Failure to Step C, BOTH would have to fail before Step C is executed. Hope that makes sense.
Post a Comment