psduplessis,

thank you for the detailed solution.

I also tried to use the rowcount task instead of aggregate task and it seems to work too. I did not need to...

pduplessis,

would it be possible to explain in detail how to do aggregate in muticast task and use the variable in the send email task.

Thanks!

I am trying to send the entire resultset from sql task to email task using the steps that are mentioned in this thread. I cannot assign a variable defined as...