How to display number of rows imported in the SSIS Send Mail Task

0
votes

In SSIS, I want to send a mail stating the number of rows imported by a "Data Flow Task".

How can I get the number of rows imported in the "Send Mail Task"?

1
ssissendmail

1 Answers

3
votes

This Microsoft KB article covers what you're after in the enclosed example, using a variable and a row count transform, together with an expression for the mail subject (body would be similarly do-able).