| Author |
Looping Orchestration Message
|
|
| CranCran77 2005-04-28, 5:55 pm |
| I have a message that is coming into my biztalk orchestration that
requires me to insert a header record into table1 and then loop
portions of the incoming mesage to insert records into table2 for the
lines associated with the message.
Could someone be able to send or post an example project of how to do
this? A sample input XML document would be like:
<Order>
<Header>
<OrderNumber>1235</OrderNumber>
<SalesRep>PERSON</SalesRep>
</Header>
<Line>
<Item>item1</Item>
<Price>25.25</Price>
</Line>
<Line>
<Item>item2</Item>
<Price>5.50</Price>
</Line>
</Order>
Thanks!
| |
| CranCran77 2005-04-28, 5:55 pm |
| Please disregard my XML above and use the following:
<Order>
<Header>
<OrderNumber>1235</OrderNumber=AD>
<SalesRep>PERSON</SalesRep>
</Header>
<Lines>
<Line>
<Item>item1</Item>
<Price>25.25</Price>
</Line>
<Line>
<Item>item2</Item>
<Price>5.50</Price>=20
</Line>=20
</Lines>
</Order>
| |
| Romualdas Stonkus 2005-05-14, 1:16 pm |
| Hello,
You can find a sample on Darren's blog:
http://blogs.msdn.com/darrenj/archi.../30/222614.aspx
Just a note: looping through the lines in the orchestration is kind of slow
;) Splitting the message using envelopes works much faster.
Romualdas Stonkus
MVP - BizTalk Server
"CranCran77" <crancran@gmail.com> wrote in message
news:1114701264.322393.282390@z14g2000cwz.googlegroups.com...
>I have a message that is coming into my biztalk orchestration that
> requires me to insert a header record into table1 and then loop
> portions of the incoming mesage to insert records into table2 for the
> lines associated with the message.
>
> Could someone be able to send or post an example project of how to do
> this? A sample input XML document would be like:
>
> <Order>
> <Header>
> <OrderNumber>1235</OrderNumber>
> <SalesRep>PERSON</SalesRep>
> </Header>
> <Line>
> <Item>item1</Item>
> <Price>25.25</Price>
> </Line>
> <Line>
> <Item>item2</Item>
> <Price>5.50</Price>
> </Line>
> </Order>
>
> Thanks!
>
|
|
|
|