Hi:

I want to write to a database when a task in my package fails. I would
like the database record to look like:

Status FailTime FailedTask
Failed 4/22/2005 8:34 PM DataPumpTask1

How can I do this?

2. I also want to use this information to for the email message, so the
person getting the email will know what task failed and when. This
would be better than using an email task for every task that fails I
think. I imagine I would use an ActiveX script to query the database
and build a message.

Thanks for any help,
Kayda

The easiest way to do this is to call the package from a language such as VB especially if you do not want to start making multiple
copies of an error handler task.

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"kayda" <tabladude (AT) gmail (DOT) com> wrote