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

Getting error trying to exe msdb.dbo.sp_send_dbmail in EXE SQL Task Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 3:54 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 1:28 PM
Points: 280, Visits: 622
Im trying to run the following in an exe sql task in ssis 2008


EXEC msdb.dbo.sp_send_dbmail
@recipients = 'danny.daughtery@MyEmail.com'
,@copy_recipients = 'danny.daughtery@MyEmail.com'
,@subject = 'Menu Controls (AS400LS) - Associate Menu Change'
,@body = 'html code in here'
,@body_format = 'HTML'
,@profile_name = 'WPNOA0DDPDB'






But Im getting the following error. CAn someone please assist?

[Execute SQL Task] Error: Executing the query
"EXEC msdb.dbo.sp_send_dbmail
@recipients = ?

,@c..." failed with the following error: "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,
parameters not set correctly, or connection not established correctly.
Post #1437120
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse