Send mail with resultset using script task

• Shanmuga Raj

  Ten Centuries

  Points: 1178

  More actions

  September 25, 2013 at 7:14 pm

  #395557

  Using Script task i have to send data records. I am aware of send mail via script, need help on passing the recordset as object to send mail function.

  If data is found in error table for a query,Get set of records from table.

  Send mail to user with the error records row using script component.

  My scenario is as below,

  If SourceRowCount = DestinationRowCount then

  send success mail.

  else

  send failure mail with the data in the error table as attachment

• herladygeekedness

  SSCertifiable

  Points: 5878

  More actions

  October 1, 2013 at 11:45 am

  #1654998

  Is there a reason why it has to be in script task? I use Execute SQL task to pull select validation records from a table and email that.