FlatFile

Viewing 1 reply thread
  • Author
    Posts
    • #14968

      Hi!
      I have a flat file, with header,body and end file.. the header and end file, are only ones, but the body have some records.. How i can to read all the records in the body? only i have one header and end file… I want too, if all the validate property fields in the flat are right, and depend their values, build other message, and if not right, build a error message; finally, i want to insert the right values in a sql database.. Can something to help me?
      Sorry by my english

    • #14969

      It might help to take a look at some of the flat file samples and the video I have on this site.

      Basically, you need to define three schemas and set this inside the flat file disassembler.

      Your header and trailer validation is a little more tricky. If the file was smaller (less then 5 MB or so) I’d probably put the whole message into an Orchestration and run your validation. Otherwise, in the past I have put .net components that I called from the Orchestration to run extensive header trailer validation for larger file.

      Hope this helps.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.