Re: How to transform a flat SQL result set into a nested xml structure in BizTalk

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

#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.