This article was extremely helpful, but I have run into a snag.
This works great and it sends me the email I need when executing in BIDS, but once I schedule the package as a Job in SQL Server 2008 the email gets sent to me blank.
Any suggestions would be fantastic.