This is my first SSIS package, please forgive me if seems like to simple of a question. I am working on to enhance a existing SSIS package that currently takes a csv file transforms the data into SQL Server 2008 database table. I need to take that table and break it up into 3 tables which I have already created 3 separate stored procedures for each table. First need to call the stored procedure separatley so if one errors the error handling will SEND MAIL and continue on with the next stored procedure. The only thing I pretty sure of is need at least 1 or maybe I need 3 Execute SQL Task and Send Mail Task. Please someone tell how many I need and how should they the connected. Thanks for any help!

you can add EVENT HANDLER for ONERROR on each execute sql task, or on Whole package, and put send mail task there, then you can use SourceName for get the task name which cause the error, read this material for how to use event handlers in SSIS: http://technet.microsoft.com/en-us/library/ms139744%28SQL.90%29.aspxhttp://www.rad.pasfu.com