• You'll need to use Rowcount transformations in each dataflow to store the count of extracted/inserted rows in a number of user-defined variables. You can then reference those variables in your Send Mail task.

    As you are new to SSIS, I recommend taking a look at Andy Leonard's 'Stairway to Integration Services' series of articles on this very website: http://www.sqlservercentral.com/stairway/72494/

    Regards

    Lempster