1 flat file to many XML

hai friends,
I have a flat file and i want to split into different XML documents.

My flat file looks like this :
@
kavitha
27
@
arava
35
@


I want to split each record into separate XML document as Output.
My output should look like

<name>kavitha</name>
<age>27</age>

I tried many times but i did not get the results.Can anybody give me a clue to do this.

Thanks in advance

kavitha

Biztalk maps (and XSLT 1.0) can only output one XML file.
Sounds like this is a case for a custom disassembler in a Receive Pipeline
or use some type of C# preprocessor to split the file first.

On this website (BiztalkGurus.com) Stephen Thomas has several examples of debatching, but I'm not sure that applies in your case, but you might get some ideas. Debatching is taking one big message, and breaking it into several smaller ones.


Neal Walters
http://Biztalk-Training.com

Use XPATH in The Orch...

Root
subroot
<name>YYY</name>
<age>11</age>

xpath(msg, \"count(//subroot)\")

when ever you send input file, it will split on every subroot record.

you always get out like Name and age in single file...

try this hope this Helps

Reddy-

This can be done by the Flat File disassembler.
Although you need to know the exact character layout of the file.

If you can email me an example of you input file I can show you how to create the schemas required.