Best approach for multi-file data transformation?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Best approach for multi-file data transformation?

Viewing 1 reply thread
  • Author
    Posts
    • #22662

      All,

      I need to perform a data transformation and will have two (or maybe three) input files that get merged and filtered into a single output file.  Unfortunately it’s not XML but delimited.

      Is there an easy way to do this using BizTalk’s native functionality, or am I better off writing a WCF service that does the transformation?

      Thanks in advance.

      g

    • #22665

      Biztalk has the facility to convert a delimited flat file into Xml. You define the flat file using an Xml schema with special extensions. There is a wizard to assist that uses an example of your flat file.

      A component called the Flat File Disassembler is used in a receive pipeline to convert the Flat File into Xml using your schema definition.  You would create 3 receive locations each with a receive pipeline to disassemble each type of flat file.

      You would use an orchestration to map the 3 incoming files into a single outgoing file.

      On output you can use the Flat File Assembler to convert the outgoing Xml file into a flat file. You would need to define a fourth flat file schema for the outgoing file.

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