SQL ResultSet in Body of Email in SSIS

• Pack_Star

  Mr or Mrs. 500

  Points: 547

  More actions

  October 2, 2015 at 4:41 am

  #301180

  Hi Gurus,

  I am trying to email an SQL Result Set in the body of an email based on an email address. My query is as follows-

  SELECT Name, Email, 'Msg Id', 'Msg Date', 'Message'

  FROM Table

  Which produces output as shown in attachment Main. I need to split the output and send the result sets in the body of the email to the relevant email address, as shown in attachments Main_2 & Main_3.

  So far I have created an Execute SQL Task, I have Joined this to a For Each Loop Container. I have also created the following variables:-

  **Variable Name** **Data Type**

  Email_Ob Object

  QueryResult Object

  EmailTo_Str String

  I have then configured the Collection parameter in the For Each Loop Container as shown in the ForEachLoop attachment.

  Can you please advise on what I need to do to complete this solution.

  Kind regards