I had the same problem and couldn't see an obvious solution. I have resorted to using a SMTP protocol on a 'master' server which uses DTS jobs to check things and mail out.
http://www.sqldev.net/dts/SMTPTask.htm
Has a SMTP step you can install and use in DTS packages