How to process the delimited flat file with tag identifiers not at the beginning-Grouping-Debatching

Today, I have posted my first TechNet Wiki article today. This article is based on one of the questions in MSDN BizTalk forum.

Questioner wanted to

  • Create a flat file schema for delimited file with tag identifiers for header and detail which is not at the beginning of the record.
  • Group the header and detail based on a date field.
  • Debatch the grouped record by date.
Delimited flat file with tag identifiers not at the beginning-Grouping-Debatching

Flat File Structure

This is a delimited flat file with tag identifier for header and detail. As you can see, the tag identifiers are not at the beginning of the data for a delimited record. And questioner wants to debatch the file by date. So its about how to process the delimited flat file with tag identifiers not at the beginning-Grouping-Debatching.

I though I would detail the solution for this requirement by posting an article in TechNet-Wiki and Code-Gallery contain the complete source code for this solution.

Article can be found here: BizTalk: Generating Flat File Schema for File with Tag Identifiers not at the Beginning, Grouping Data by Element and Debatching

Code can be found here: TechNet-Code gallery

Posted in: BizTalk, Flat File Schema Tagged: , , 4 Comments September 18, 2013

About M.R.ASHWINPRABHU

M.R.ASHWINPRABHU is the founder and CEO of Fortuvis Systems Limited, a consulting company specialised in Microsoft technologies. Ashwin is a highly experienced integration consultant who works with clients to deliver high quality solutions. He works as technical lead developer, application architect and consultant, specializing in custom applications, enterprise application integration (BizTalk), Web services and Windows Azure.

Comments (4)

  • Selena December 11, 2013 - 5:37 pm Reply

    Major thankies for the blog post.

  • migliori tablet June 19, 2015 - 10:18 am Reply

    I’m now not certain the place you’re getting your info, but great topic.
    I must spend a while learning more or working out more.
    Thank you for excellent information I used to be on the lookout for this info for my mission.

  • Cheryl December 30, 2015 - 1:56 am Reply

    Hi my friend! I wish to say that this post is amazing, nice
    written and come with almost all important infos.

    I’d like to see extra posts like this .

  • Tina January 3, 2016 - 9:24 am Reply

    It’s going to be ending of mine day, but before ending I am reading this impressive piece
    of writing to improve my experience.

Leave a Reply

Your email address will not be published. Required fields are marked *