[BizTalker] Mapping Question

[CRANFORD, CHRIS]

I am trying to develop an orchestration that will take an input XML document in the following form:

 

<Order>

  <Header>

    <Number>1234</Number>

    <OrderDate>04/31/2005</OrderDate>

    <TotalCost>25.00</TotalCost>

  </Header>

  <Lines>

    <Line>

       <Item>00003948432</Item>

       <Qty>5</Qty>

       <Cost>17.25</Cost>

    </Line>

    <Line>

      <Item>3948321</Item>

      <Qty>1</Qty>

      <Cost>7.75</Cost>

    </Line>

  </Lines>

</Order>

 

I need to split this incoming message so that I can insert 3 records into my database.  The first record represents the order header and the other 2 represent each individual line.  When the lines are inserted, I also need to include the order number so I can join the values back at a later point.

 

Can someone explain how I could do this within BizTalk 2004 via a map or orchestration process?

 

Thanks!

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net