On Error Scream "Help"

Seriously, notification is another issue altogether. However, DTS is
flexible enough that it can do most things, assuming that you have some
sort of notification structure in place. If you've disabled SMTP, how
about (ugh) MAPI? How do you normally handle notification?