I have created a few DTS with about 20 steps each. I would like to get an email for the step that has failed, and only if it failed. Is there any way to create on step that will send an email with the information of all the DTSSteps if one of them failes. I am trying to create an activex and then trying to use the oStep.ExecutionResults, but from what I understand I would have to load the dts from the activex script to collect all those errors. Any other ideas

Can I use the create email task and put in the error message there? If so how. Thanks for hte help, just rying to get the most information with the least amount of work

How about adapting the script that is here

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208,2)



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"kdabda" <anonymous (AT) discussions (DOT) microsoft.com> wrote

way to create on step that will send an email with the information of all
the DTSSteps if one of them failes. I am trying to create an activex and
then trying to use the oStep.ExecutionResults, but from what I understand I
would have to load the dts from the activex script to collect all those
errors. Any other ideas?
least amount of work.