Send Mail Task - Record counts + Message Source
-
Hello all,
If I have posted this question in wrong forum , I apologize.
I am creating Flat file from Production table, Dynamically name it, zip it, ftp it ! I used lot of online help to reach here (for new-bee like me this is some sort of achievement - at least in my mind).
I want to add functionality of "send mail task" : - there are two things I want to do:
1. Capture the record counts of the flat file which my process extract, or I can run same query which runs against the table to pull the data . What I don't know how to capture the record count (in variable ?).
2. Add above in in Email body in BOLD Letter.
The challenge is , I don't want to do any scripting, everything should be done using Expression Builder or available Control Flow Items.
its not that I don't want to learn scripting but I think I am still not ready for that.
all help is truly appreciated.
Thank you !
N
PS: I welcome the advice around scripting - but it should be simple to use , otherwise I end up posting lot of questions. Remember , I am newbee !
-
Inside your data flow task, use a RowCount task and assign the result to a variable.
In your Control Flow task, add a Send Mail task and refernce the variable you assigned the row count value to.
However, changing the font to bold might get tricky... Never done it...
-
Intresting:
Currently my Data Flow Task is set up this way:
OLE DB SOURCE (Production Table) => Flat Flie Destination
I can not set this up like you suggested
OLE DB SOURCE (Production Table) => ROW Count => Flat Flie Destination
OR
OLE DB SOURCE (Production Table) => Flat Flie Destination => ROW Count
am I doing something wrong ? or you want me to set it any other way ( should row count be independent of my current configuration ?)
Again, Thank you for your time. To do BOLD letter is just my way of presenting, but it doesn't matter, we can address it late
-
Errrmmm..... I'm sorry....
I left out a "tiny" piece of information: you'd need to split the data from your OLEDB source using the Multicast data flow item.
Assign a variable to the result set of the row count item and use that in your send mail task.
It would look like this:
-
What' the best way to say "Thank you" other than THANK YOU !
You may not know - and not sure if people do it here or not - but I TRULY APPRECIATE your help.
I consider this Resolved (less part 2 - Where I want to populate the Row count in bold letters in Expression Builder of Send Mail Task)
-
Glad I could help 😀
I really appreciate your feedback!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply