Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to transform a flat SQL result set into a nested xml structure in BizTalk › Re: How to transform a flat SQL result set into a nested xml structure in BizTalk
July 13, 2010 at 1:44 PM
#25228
Hi Yusuf,
You would use the looping functoid in a map, join the left-hand side to the top-level node of your source schema, join the right-hand side to the Address node in your destination schema, make sure your Address node’s Max Occurs property is set to unbounded as the value. Then just link the fields in the source schema to the fields in the destination schema to map the data.
Daniel.