sql server dts: DTS process flow -- sql server dts

DTS process flow

Mark
8/13/2003 4:19:24 PM

sql server dts: 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!

Re: DTS process flow

Allan Mitchell
8/14/2003 7:19:51 AM

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

[quoted text, click to view]