Scenario:You are creating an SSIS Package that is loading multiple tables from different sources. You want to include logic in your SSIS Package to send Summary Email that should include records inserted, records updated in different tables.
Provide the Profile name which will be used for msdb.dbo.sp_send_dbmail stored procedure.
Provide the list of Recipients by separating them ";"
Create Integer type variable that we will use to store number of rows inserted.
Use RowCnt variable to capture row count from Source to Destination. I am loading records from SQL Source. I have used Multicast just for the test purpose to land records. You will be using your Destination that can be SQL Server Table, Flat File, Excel, Oracle etc.
Now we have record count saved in RowCnt variable, we can use this in our Load Summary.Bring the Execute SQL Task and connect to your Data Flow Task as shown below and then configure.