You can use the send mail task to send an e-mail message before or after another task has processed. For example, if a task fails, the send mail task can send a fail message to a Planning and Consolidation user. Or you can send an e-mail after completion of a certain task. You can send mail to any Planning and Consolidation user and the mail can include one or more attachments. You can add this task to your package by registering OSoftTaskSendMail2008.dll located in the Planning and Consolidation websrvr\bin folder, with the Microsoft SSIS interface. See Registering Custom Tasks.