SQL Schema error

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Schema error

Viewing 1 reply thread
  • Author
    Posts
    • February 6, 2007 at 7:55 PM #17584
      community-content

        Hi,

        I have a Flatfile schema vs SQL schema map. I used Updategram to create SQL Schema. I have 3 different tables in the SQL schema. Header, Detail and SerialNo.

        Map seems work fine but I am not sure about out put of map.

        Let say my input schema is something like this.

        Group
            H
            D
            D
            S
        /Group
        Group
            H
            D
            S
            S
        /Group

        Map out put is, all the header table records first then details table records and last serialNo table records.

        Why does the SQL Schema out put from map not smiller to the input schema?

        Why does the out put in sorted by tables?

        out put schema is something like:
        H
        H
        D
        D
        D
        S
        S
        S

        Thank you in advance,

        Siva

      • February 8, 2007 at 3:55 PM #17610
        community-content

          Try using Loop in the map.

          • February 9, 2007 at 9:09 AM #17618
            community-content

              Hi,

              Thank you for your help. I am getting another issue when I use looping functoid with "after block"

              I am getting following error:

              Out of sequence before or after elements are not permitted inside a single sync block. If there is more than one of these, every before block must be followed by an after block.

              I noticed that I have more than one after blocks under the one Sync block. I read somewhere that we can have many after block with in one Sync. Then Y i am getting this error?

              Should I have to add before block manually if i want multible after blocks? how to add? 

              I used updategram to create the SQL Adapter Schema.

              Thank you in advance,

              Siva

               

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