December 2, 2007 at 8:36 am
I have created an SSIS package that exports data from one source into staging tables. The package is very simple; consisting of a data flow task which contains a source, row count transformation and destination. In the control flow i have included a send mail task which I want to take the number of rows calculated by the row count and display it in the email message, however, i have a problem with variable scope, as the variable i created has to be of the DFT scope in order for row count to work, however, it can not be referenced by the send mail task.
Any Ideas?????
December 2, 2007 at 9:37 am
DONE IT!
Here's the solution for anyone interested!
Basically add a user variable at the package level and then use the expression editor of the message source in the send mail task. within the expression include any text you want within double quotations and concatenate your user variable which is the used as a row count. You can also use system variables to give you start times, end times and so on!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply