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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:57 PM
Points: 313, Visits: 715
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