Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Send mail with resultset using script task Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 7:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:17 AM
Points: 62, Visits: 321
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
Post #1498643
Posted Tuesday, October 1, 2013 11:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
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.
Post #1500517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse