sql server dts: Hi

I have a dts packet that copy data from 6 different
tables. If anything fails I want to send an email saing
what table who faild. Can I do that with only one "Send
mail task"?

You can use workflow so that each step is executed regardless of what
happened in the previous step.
You then at the end have an Active Script task that checks the last outcome
of each step and then set the properties of a send mail task.

Some articles to help

Changing the DTS Send Mail Task
(http://www.sqldts.com/default.aspx?235)

Introduction to Workflow
(http://www.sqldts.com/default.aspx?287)

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

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


[quoted text, click to view]