BizTalk 2006 has new Template called Flat File Schema Wizard , In this post I am going to show how we can use this Template to converting Flat File to XML message which BizTalk can understand.
Basically Inside the BizTalk only XML message are allowed. now let say we have Flat File which contains Customer profile information as shown below
Sreeni,35,232232323,email@example.com now we need to convert this text file to XML XSD Schema.
Steps needed to convert Flat File to XML Schema (XSD).
1) First Use Flat File Schema Wizard to Create XML Schema instance.
2) Create a Receive custom pipeline to disassemble the Flat File into XML file
3) Create strong name and then add SN key file to the BizTalk project, now build and deploy the project into BizTalk Message Box[ DB].
4) Configure Receive and Send ports.
5) Test the Application.
First Create a Empty BizTalk Project and Add Flat File Schema Wizard to it.
Follow the Wizard Dialog.
Please select the Flat file which needs to convert to XML Schema.
Here you edit the Element name and select the data type of each element.
Finally the Selected Flat File instance is created as the XSD Schema as shown below.
Now we need to create Receive custom pipeline to Disassemble the Flat File , Drag and drop the Flat File Disassembler from left side Toolbox in to Disassemble Stage of the Pipeline.
Configure the Receive Location with Custom Pipeline which we created.
Configure the Send port Filters as shown below.
Now drop the Flat File instance in Receive Location (IN folder) after 1 or 2 seconds BizTalk Will Get that file and push to Receive pipeline.
Input File :
Out put XML file: