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.