Getting error trying to exe msdb.dbo.sp_send_dbmail in EXE SQL Task

• dndaughtery

  SSChampion

  Points: 11290

  More actions

  March 29, 2013 at 3:54 pm

  #275922

  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.