I have a task - I need to email total number of products sold on the subject line of the mail task.
I have Execute SQL task process like select count(*) from tablename. Then I need to Mail the result set like "Total products sold September 2010 : 15000" on teh subject line.
I created a variable bit i dont know how to assign it on the subject line of the Send Mail Task.
I would really appreciate if you can guide me.
Thanks for your help.
View Complete Post