Sending query result from a table via email in SSIS in a table format

• Wicked

  Old Hand

  Points: 356

  More actions

  February 16, 2012 at 11:17 pm

  #253115

  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.

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  February 16, 2012 at 11:44 pm

  #1448284

  Please do not crosspost. It wastes people's time and fragments replies.

  Original thread with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1253582-147-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP