I'm new to DTS and I would like to know how to send an emai
notification, that is, execute an activex script if any of the task
in the package fails

I foun
"Fail Package on first error

but how do I execute VB script on this

If this has already been answered can someone point me to tha
thread

Thank

OK

The easiest way would be to use the SendMail task and have an On failure
contraint from each of your tasks to their own SendMail task.

Your text suggests Tasks failing but your subject line suggests package.



Have a look at our section here

www.sqldts.com/default.aspx?104



"anotherfinemess" wrote:

I want to send a mail if any one of the step fails in a package. I d
not want to put an "on failure" for each and every step

And there lies the problem, doing it within the package is messy. I
would call the package through code and check the steps afterwards. You
then send only 1 mail

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

Execute a package from a package
(http://www.sqldts.com/default.aspx?215)




"anotherfinemess" <crusadertotherescue (AT) gmail-dot-com (DOT) no-spam.invalid>
wrote in message news:crusadertotherescue (AT) gmail-dot-com (DOT) no-spam.invalid:

Thanks for the reply

but I'm not using VB, I'm using SQL Server Agent job to schedule th
DTS

If you are executing the dts package from a job you can send an email from
the job. Take a look at the Notifications tab in the job properities. You
may have to add an operator in Enterprise Manager. Does this help?


"anotherfinemess" <crusadertotherescue (AT) gmail-dot-com (DOT) no-spam.invalid> wrote
in message news:m92dnVu-EpowFKvfRVn_vg (AT) giganews (DOT) com...