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: Tuesday, March 18, 2014 3:26 AM
Points: 61, Visits: 317
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 01, 2013 11:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:21 AM
Points: 285, Visits: 768
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