XML to Flat file via send pipeline

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

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.

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 :)