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.