Also, on #1, I'd point out that sending an email upon failure is a notification, not exception handling. If I wrote a spec and asked for exception handling, I would intend for something more robust.
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices