XML to Flat file via send pipeline

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › XML to Flat file via send pipeline

Viewing 1 reply thread
  • Author
    Posts
    • July 31, 2006 at 2:45 PM #14070
      community-content

        Hi

        Can someone tell me where i’m going wrong here. I have an xml file coming in, a pipeline on the send port that specifies a schema in the flat file assembler (this schema should represent the format of the file coming into the pipeline, yes?) and the send port specifying that a txt file is output to the right location. All my ports have the correct spellings of folders and are all running, everything is deployed as it should be. When I copy my xml file to my receive folder it is deleted but the flat file formatted file is not output to the send location.

        I get the following error in the HAT on my custom pipeline:

        There was a failure executing the send pipeline: \”BTSDG_FF.ff_send_pipeline\” Source: \”Flat file assembler\” Send Port: \”\\\\biztalkdev\\jodaydev$\\Chp13\\BTSDG_FF\\out\\%MessageID%.txt\” Reason: Loading document specification <BTSDG_FF.FF_xml> from assembly <BTSDG_FF, Version=1.0.0.0, Culture=neutral, PublicKeyToken=5af53d486044ac07> failed. Verify that the schema is deployed properly and that the schema assembly implements the document spec.
        Microsoft.BizTalk.Component.Interop.DocumentSpecException

        Have I missed something out in the process? Has anyone out there done a similar process of xml to flat file?

        Cheers

        • August 1, 2006 at 10:30 AM #14071
          community-content

            Hi there

            Possibly one of the best straightfoward answers ever. I have applied a map and adjusted my pipeline with the correct schema and all works perfectly.

            Many thanks for your help 🙂

        • July 31, 2006 at 6:06 PM #14069
          community-content

            The schema you select for the Flat File Assembler should describe the out Flat File Format.

            Sure, the XML document you send through the pipeline has to match that spec as well, but my point is that you can’t take any random XML schema and use it to generate a flat file, but instead you need to create a special purpose schema that describes your flat file format.

            Now, if your incoming XML document doesn’t match your Flat File Schema, then you’ll need to create and use a Map so that you can convert between the two representations and that way you’ll be able to successfully send the message through the pipeline and get a Flat File as output.

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