How to send query results extracted from an execute sql task and then send it via email by script task using HTML formatting?.
I was able to send the query results using execute sql task then a for each loop container inside which i had a script task where the results were (stored in variables) appended to a string.
Then i sent the string using send mail task.
By this method i was able to seperate the query results with help of TAB's.
But i have to get that in a table format.