i have a table with two columns and two records as follows.
I have a package with execute sql task selecting * from the table above, full result set selected and an object variable created, it works good. but now when i connect it with send mail task, i wanna send email like
Subject : Reports On InvalidRecords and MissingRecords
MessageText : Links for the Reports : http://ReportInvalid
Can somebone help me with it.
NOTE : i tried creating user and object variable but its good if i have only one record in table. i tried creating 2 user and 2 object variables as well but didnt work.
View Complete Post