Suggest me best way

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Suggest me best way

Viewing 2 reply threads
  • Author
    Posts
    • November 10, 2006 at 10:29 AM #16388
      community-content

        Hi,

        Here is the Scenario How My Client Wants:

         

        1 Input\Request , I have to make 4 SQL Calls (I have 4 Select_SPROCS,with coman request) and generate 4 SQL Responses and all SQL Responses Map to Final XSD  that is the Final Output.

        ========================================================================

        I tried this in 1 Orchestration, got SQL SendPort Namespace and RootNode Issue.

        Then i made every process saparate Orchestration(4-Orch) and got 4 final Output(all same namespaces), my client need only 1 final output merging all out puts.

        i am looking better way to handle this process or how can i merge 4 final outputs to 1 xml.

        Any help appreciated.

         

         

         

      • November 10, 2006 at 11:31 AM #16389
        community-content

          One solution might be that rather than calling the Sql server from your orchestration directly,  you do this in a .net component, Get all the results in a DataSet, return it to your orchestration, and then use it for building up the final message.

           

          Regards,

          Sajid. 

           

        • November 10, 2006 at 12:59 PM #16390
          community-content

            I would have each orchestration return an instance of its own sql response through 'Call Orchestration' shape.  When you have collected all four responses map them to the final output message.

             

            • November 10, 2006 at 5:57 PM #16391
              community-content

                Thanks for your respnse sajid and DM

                That's what i am working know DM. Got All Reposes and Created Source Schema(Imported 4 Response Schemas) and Mapping to Final Output XSD.

                I am getting some RootNode Issues, i created this map from Orchestartion New Map Process, still working on it. No Luck Yet.

                 

                 

                • November 15, 2006 at 7:55 AM #16430
                  community-content

                    Scope and parlle shapes solved the process in one orchestration.

                     

                     

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