One XML message into 2 sql tables

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › One XML message into 2 sql tables

Viewing 1 reply thread
  • Author
    Posts
    • March 1, 2006 at 9:13 PM #13025
      community-content

        Hello

        This is my scenario.

        I receive an XML message which is a purchase order. It has a heade section with all the Order details and then numerous lineitems associated with that order.

        The goal is to insert the order details into an ORDERS table and the Lineitems into a LINEITEMS table with a key associating each lineitem to an order … pretty basic stuff right?

        Well I found this great tutorial here

        http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp

        The ‘Insert New Orders’ section is exactly what I want – EXACTLY!

        However when I try to build and deploy I get quite a few errors.

        Has anyone tried this tut or can anyone help me?

        Regards
        JMan

      • March 1, 2006 at 9:58 PM #13026
        community-content

          Hello

          Here are my errors ….

          Orchestration.odx(239): ‘InsertOrder’: message has not been initialized in construct statement

          Orchestration.odx(242): #error: \”Missing or invalid mapping configuration.\”

          Orchestration.odx(245): use of unconstructed message ‘InsertOrder’

          Thanks
          JMan

          • March 2, 2006 at 10:59 PM #13027
            community-content

              You were totally correct – I have redone it and it worked.

              Thanks a million

              Regards
              JMan

              • March 1, 2006 at 9:25 PM #13028
                community-content

                  What are the errors that you are getting?

                  • March 1, 2006 at 10:27 PM #13029
                    community-content

                      These errors all relate to the Transform shape in the orchestration.

                      Did you complete all instructions in steps 4,5,6 of [b:6d9b33a6aa]To complete the orchestration[/b:6d9b33a6aa]

                      When you add a Transform shape you actually get two shapes:
                      A [b:6d9b33a6aa]Construct Message [/b:6d9b33a6aa]shape where you need to set the [b:6d9b33a6aa]Messages Constructed[/b:6d9b33a6aa] property to [i:6d9b33a6aa]InsertOrder[/i:6d9b33a6aa]
                      And
                      The [b:6d9b33a6aa]Transform[/b:6d9b33a6aa] shape where you set the map and the input and output messages.

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