OK, I'll step it out for you.

1. Add a Send Mail Task to your Control Flow, connect it after success of the previous task we set up (Execute SQL).

2. Open the new send mail task. Go to the Expressions tab.

3. Click on the elipses (...) button, then, under Property column, click in the open space and reveal the property drop down.

4. Select the 'MessageSource' property and open the expression builder.

5. This is where you can build your expression. So, for starters, expand the folder 'Variables and Parameters' to reveal the variable holding your value. Drag that variable down into your 'Expression:' window. Add (DT_WSTR,10) directly in front of your variable to cast it to string. (example: (DT_WSTR,10)@[User::myCount])

6. Click on Evaluate Expression to see the result.

7. Click OK to exit the Expression Builder.

8. Go the the Mail tab and configure the rest of the mail task.

>>SMTP connection

>>From

>>To

>>Subject

>>MessageSource - leave this alone as your expression evaluates this at runtime.