The adapter "SQL" raised an error message. Streaming not supported over multiple column result

Home Page Forums BizTalk 2004 – BizTalk 2010 The adapter "SQL" raised an error message. Streaming not supported over multiple column result

Viewing 0 reply threads
  • Author
    Posts
    • #15721

      I get the following error with my SQL send/receive port.

      The adapter "SQL" raised an error message.Streaming not supported over multiple column result.

       I don't know if this error is related to the way I have built my stored proc? This is it anyway:

       PROCEDURE [dbo].[sp_SendEmail]
       @EmailID as int,
       @EmailTo as nvarchar(50),
       @EmailFrom as nvarchar(50),
       @EmailContent as nvarchar(250)
       
      AS
      BEGIN

       DECLARE @mailitem_id int

       EXEC msdb.dbo.sp_send_dbmail
         @subject = @EmailSubject,
         @profile_name = 'myProfile',
         @recipients = @EmailTo,
         @body = @EmailContent,
         @mailitem_id=@mailitem_id OUTPUT;

       — return the mailID
       SELECT @mailitem_id as SysMailID for xml raw
       
      END

      Did someone have an idea of what could be the problem? Thanks for your help.

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.