Sql adapter receive multiple table result sets in one call?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Sql adapter receive multiple table result sets in one call?

Viewing 1 reply thread
  • Author
    Posts
    • February 16, 2006 at 2:48 PM #12906
      community-content

        I want to return multiple results via one stored procedure call. Is this possible? I haven’t found anything online about this. I know that I have to generate each schema and put them into one final schema separately – but I’m not having any luck actually getting the results back correctly.

      • February 16, 2006 at 6:54 PM #12907
        community-content

          Yes, I’ve proved that it works once, about a year ago.

          If I remember, seems like you create an xml doc with two root elements, and each result falls into the proper root.

          Neal Walters
          http://Biztalk-Training.com

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