BizTalk Server Tutorial

BizTalk Server Concepts and Common Errors

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

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


September 22, 2011 - Posted by | Schemas | ,


  1. 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.


    Comment by Anonymous | April 10, 2012 | Reply

    • 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.

      Comment by Shiv | April 10, 2012 | Reply

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: