Unanswered: Send Mail Task Issue with values stored in variable of object type
I have a small assignment like explained below:
1. I have to collect some table data using a execute sql task into a variable of object type. The reason it is of object type is because I want the output of the query into this variable and then I want to use the data stored in this variable and pass it as the body of the message in my send mail task.
NOTE: I dont want to send the output of the query into some flat file and attach the flat file as an attachment in send mail task.
Please suggest me some solution as early as possible.