streaming not supported over multiple column result

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › streaming not supported over multiple column result

Viewing 1 reply thread
  • Author
    Posts
    • #23832

      Hi,

      I am using SQL receive adapter to read new invoices information from SQL database using SQL stored procedure. My stored procedure is returning XML data using for XML AUTO in SQL 2000.

      It is working fine till date but all of sudden I am getting streaming not supported over multiple column result error while calling stored procedure using SQL adapter.

      Please note that we have neither changed SQL procedure not changed BizTalk orchestration.

      Can anybody suggest me the solution for this problem?

      Thanks in advance.

      Regards,
      Dhaval

    • #23833

      This error is generated from the SQL adapter, it means it is getting a dataset response instead of Xml.

      Had this exact problem yesterday, someone had “temporarily” commented out the FOR XML in the stored procedure so they could view the result in tabular format. They forgot to remove the comment and reinstate the FOR XML.

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