How to Debatch (Split) a Flat File using Flat File Schema ?

Posted: September 22, 2011  |  Categories: Schemas Uncategorized

This MSDN clearly shows how to generate a Flat File Schema using Flat File Schema Wizard.

But what If you want to debatch the flatfile in to individual xml’s ? This scenario is often required in many instances. Lets see that in this article.

Image you have a flat file with 3 Records as below

Using Flat File Schema Wizard generates a schema as shown below.

When you test your input with the schema generated, you get an XML file as below.

What exactly we need is each record should be  a separate XML file.

Here are two simple steps to achieve this.

1. Set “Allow Message Breakup At Infix Root” to “Yes” by selecting “Schema

2. Set “Max Occurs” to 1 by selecting the “Employee” Record.

Now if you test your solution with a Flat File Disassembler component in the Receive Pipeline, you can find that each record will be split up into a separate XML File.

Hope it helps.

– Shiv

  • Anonymous

    Hi Shiv,

    Could you please help me to validate the debatching functionality. after doing all setting I’m getting on single file and it is not in xml format.

    Thanks,
    Madhukar

    • Hi, The details you gave are not sufficient. You explain your complete problem using contact me page with your mail id, so that I can get back.
      Regards, Shiv.

One Platform Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

One Platform - Operations, Monitoring and Analytics Software
BizTalk360

microsoft biztalk

Learn more

Over 500 customers across 30+ countries depend on BizTalk360

One Platform - Operations, Monitoring and Analytics Software
ServiceBus360

Azure service bus

Learn more

Start managing your Azure Service Bus namespaces in minutes

Back to Top