I have these three tables say ProductCategory, ProductSubCategory and ProductSubSubCategory (I am sure you can extrapolate the relationship). I need to create an xml file with the hierarchy something similar to the snippet below. What is the best way of achieving this in Biztalk?
<?xml version="1.0" encoding="utf-8"?> <ProductCategory Id="10000" Name="Bikes"> <ProductSubCategory> <Id>1</Id> <Name>MountainBike</Name> <ProductSubSubCategory> <Id>10</Id> <Name>Hero</Name> </ProductSubSubCategory> <ProductSubSubCategory> <Id>11</Id> <Name>Avon</Name> </ProductSubSubCategory> <ProductSubSubCategory> <Id>12</Id> <Name>BSA</Name> </ProductSubSubCategory> </ProductSubCategory> <ProductSubCategory> <Id>2</Id> <Name>RacingBike</Name> <ProductSubSubCategory> </ProductSubSubCategory> <Id>21</Id> <Name>HeroR</Name> <ProductSubSubCategory> <Id>22</Id> <Name>AvonR</Name> </ProductSubSubCategory> </ProductSubCategory> </ProductCategory>