Parsing a single Flat file to multiple XML files

Home Page Forums BizTalk 2004 – BizTalk 2010 Parsing a single Flat file to multiple XML files

Viewing 1 reply thread
  • Author
    Posts
    • #22566

      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!

    • #22569

      There are a bunch of resources on the web that help you do this, including:

      Hope this helps. Rgds, Nick.

      ps. You will only need a single Flat-File Disassembler component in your pipeline!

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.