Hi Paul ,

IMO SSIS is a bit of a beast and has quite a steep learning curve.

You can email direct from sqlserver though , i would suggest taking that route unless you have a specific reason not to.

http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm