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
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: Tuesday, September 29, 2015 3:19 PM
Points: 386, Visits: 884
Im trying to run the following in an exe sql task in ssis 2008

EXEC msdb.dbo.sp_send_dbmail
@recipients = ''
,@copy_recipients = ''
,@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