Thursday 31 July 2008

Delimited Flat File BizTalk

I have been receiving lot of mails for how to create delimited flat file in Biztalk. I know this is very simple and basic thing , however the new learners could be a difficult.

Guys who are expert in creating flat file ,please ignore this.

Delimited Flat File Settings

Schema Level- Properties

Schema Editor Extensions = Flat File Extension
Default Child Delimiter Type = None
Default Child Order = Conditional Default






Root level Properties - It identifies /n or /r/n Character
Child Delimiter = 0x0D 0x0A ( for unix 0x0A )
Default Child Delimiter Type = Hexadecimal
Default Child Order = Postfix



Record level Properties - It identifies , Character for records
Child Delimiter = ,
Default Child Delimiter Type = Character
Default Child Order = Infix


Example : Save below data into Abc.txt
1,John,5600,A
2,Alister,5800,B
3,Philip,5600,A
Let me know if you need any more clarifications , you can reach me at raj.webjunky@yahoo.com

No comments:

Post a Comment