How to break up SQL into multiple messages

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to break up SQL into multiple messages

Viewing 1 reply thread
  • Author
    Posts
    • #18345

      I have a XML message from a SQL adapter coming into my system.  The top headers look like this

       <OUTBOUND_SALES_ORDER>

                     <PRFX>…..</PRFX>

                     <PRFX>….</PRFX>

       </OUTBOUND_SALES_ORDER>

      What I need to do is break each of the PRFX portions off and into their own messages.  I defined OUTBOUND_SALES_ORDER as the envelope for the PRFX tags but when it comes into the system, Biztalk treats it as a single message (at least I didn't have two seperate sends in my HAT)… How can I get it to break up into two seperate PRFX messages?

    • #18346

      Actually, I went back and looked at my code.

       The code starts off as

       <sql_salesorder>

                <OUTBOUND_SALES_ORDER>

                         <PRFX></PRFX>

                         <PRFX></PRFX>

                </OUTBOUND_SALES_ORDER>

       </sql_salesorder>

       My envelope processing leaves me with the message above.  Which is a problem for me…. But appears to be more SQL related than Envelope processing… Anybody have an idea on how I can code an explicit XML query so that I'd get

       <sql_salesorder>

                <OUTBOUND_SALES_ORDER>

                         <PRFX>

                </OUTBOUND_SALES_ORDER>

                <OUTBOUND_SALES_ORDER>

                         <PRFX>

                </OUTBOUND_SALES_ORDER>

       </sql_salesorder>

      Instead of the above where both of the PRFX's are in the same <OUTBOUND_SALES_ORDER> tags.  I tried using a cursor to select one at a time, but it doesn't appear to be working.

      • #18350

        Ah never mind…. I rewrote the query to output each of the possible PRFX queries as a seperate SQL query and BTS picked them up and handled them as individual messages as I needed it too… Thanks!

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