How to track repeting record data using BAM in biztalk

hi all,

  new bam, how can how track repeting record data using bam in biztalk,please find below input record

<ns0:employee xmlns:ns0="http://biztalk_.employee.schemas.emp_in">
  <emp>
    <id>122</id>
    <sal>222222222</sal>
    <name>.srinu</name>
    <dept>java</dept>
  </emp>
   <emp>
    <id>666</id>
    <sal>44444444</sal>
    <name>.srinu</name>
    <dept>java</dept>
  </emp>
   <emp>
    <id>333</id>
    <sal>7777</sal>
    <name>.biztalk</name>
    <dept>c#</dept>
  </emp>
</ns0:invoice>

am tried using tpe showing 3 rows null  in bam primary import database.

so please let know how can achieve above issue.

regards,

srinivas

hi srinivas,

using tpe cannot process repeating records. doesn’t allow loop through invoicedetails (repeating record), hence shows null in tracked record. 1 of limitations when use tpe.

this can done using bam api. if use orchestration or writing custom pipeline component can use bam api have flexibility loop through repeating record , insert each invoicedetails node record in bam activity. bam api option track repeating items inside message separate activity instances.

refer msdn article more info:http://msdn.microsoft.com/en-us/library/aa559527.aspx

---

if answers question please mark accordingly. if post helpful, please vote helpful clicking upward arrow mark next reply.

BizTalk Server  >  BizTalk Server General