Processing flatfile into xml file

See more:

biztalk

Hi,

I have a flat file with around 90 lines of input data. the inpu xsd file created has elements like appid, forename,dob,surname, ENAME etc. So my flatfile would look like as below.

1 abc 10/11/2007 xyz
1 qbc 10/11/2007 xyz, HP
1 dbc 10/11/2007 xyz
2 hbc 10/11/2007 xyz
3 afc 10/11/2007 xyz
4 gbc 10/11/2007 xyz
4 wbc 10/11/2007 xyz

here the there are around 3 lines having same authid, so these 3 records need to be dispalyed as a single record in the single output xml generated.the output xml looks as below.

OUTPUT XML FILE

<BATCH>
<HEADER>
<COUNT>1<COUNT>
</HEADER>
<CUSTOMERS>
<CUSTOMER>
<AUTHID>1</AUTHID>
<FORENAME>ABC</FORENAME>
<DOB>10/11/2007</DOB>
<LASTNAME>XYZ<LASTNAME>
<CUST_EMP>
<ENAME>HP</ENAME>
</CUST_EMP>
</CUSTOMER>
</CUSTOMERS>
</BATCH>

SO as shown under CUSTOMER i need to get all details displayed related to authid 1. so it is like theer is main customer who has employment details,address details,joint customer details etc which all will be linked based on the authid.CUSTOMER RECORD NEED TO BE GENERATED FOR EVERY AUTHID, SO IN THIS THEER WILL BE 4 CUSTOMER RECORDS.

Note: the employement/address details etc need to be checked and mapped to destination schema in map files using a Type field in the source schema.

So how to achieve this in biztalk server 2004? Can anyone please help/suggest on this issue.