thanks for all the suggestions. however, what i did (months ago) to solve the problem is to run the xp_sendmail stored proc inside an Execute SQL task. i use an...

Thanks. I'm trying to look at other methods to send the notification email.