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 | ,

2 Comments »

  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.

    Thanks,
    Madhukar

    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:

WordPress.com Logo

You are commenting using your WordPress.com 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: