HI All

I have a source document which looks like follows:


<root>
<elements>
<element1>1</element>
<element2>
<element3 Name="name" Address="address" />
<element3 Name="name" Address="address" />
</element2>
</elements>
</root>


destination document like follows:


<ns0:root xmlns:ns0:="http://xyz">
<ns0:sync>
<ns0:after>
<elements element1="1" Name="Name" Address="address"/>
</ns0:after>
</ns0:sync>
</ns0:root>

I want to stored above in coming message in SQL Database

I try with looping functoid,index functoid but iam getting 2 records
while i am storing in database.
In database it is storing like this
this is first record
1  (element1)
xyz (name in element3)
3521 NJ  (address in element3)

this is second record
1   (element1)
xyz   (name in element3)
3521 NJ   (address in element3)

Can any one help me.

thanks
wask

[ Post a follow-up to this message ]