I'm setting up a package with 15 or so steps. I want to
set an error variable and then use a ActiveX script to
email the value of the error variable (which step, etc) if
the step fails. My plan was to do a process flow failure
from each step to just one ActiveX task. My ActiveX task
won't run if I run multiple process flows into it. It
works fine if I have an ActiveX task for each step but
that seems to be very redundant when the only thing I need
to change is the message.

Thanks in advance for any help!
MarkA

That is because the constraints are ANDed and you want ORed

Introduction to Workflow
http://www.sqldts.com/default.aspx?6,107,287,0,1

Also

Multiple Paths in Workflow
http://www.sqldts.com/default.aspx?6,103,218,7,1

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Mark" <mark.axland (AT) removethisinfousa (DOT) com> wrote