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.
send failure mail with the data in the error table as attachment