Hi,
I am a newbie to Biztalk..Would really appreciate any help on this!
I am trying to parse a single flat file to multiple xml files.
For example, consider this sample flat file where each row represents an item description.
Item1 200 Sold CompanyA
Item2 300 Sold CompanyB
Item3 400 SOld CompanyC
I need this flat file to be split to 3 XML files where each XML file represents a row(with Envelope information.)
This is what I have done so far:
(1) I used the Flat file schema wizard, to generate a schema for the flat file.
(2) I created a Receive pipeline wherein I use the “Flatfile Disassembler” to convert the flat file to XML file.
(3) I created a Envelope schema and I am using the “XML Assembler” on the Send Pipeline to add the envelope info to the XML file.
To break down a XML file to multiple XML files, we use the XML disassembler. So I tried adding a XML disassembler right after the flatfile disassembler in the Receive pipeline. But after further research, I understand that the flow does not come to the second disassembler.
So, now I am getting a SINGLE XML file as the output with all the item descriptions(and envelope info) but not seperate ones. I seem to be missing some configuration. There was this mention of setting the “MAX OCCURS” to *(unbounded) in the envelope schema. I tried that but it doesnt seem to be working.
Please advise as I have been trying to figure this out from quite some time!
Thanks!