Re: Flat File assembler with header





"Tomas Restrepo (MVP)" wrote:

> Yoann,
> >
> > in my project i need to send a flat file with one line in header and
> > sevral
> > line in body.
> > header and body have not same number of field.
> > both are construct in an orchestration.
> > how can i use the custom send pipeline with a flat file assembler to
> > construct this file ?
>
> Normally, the way this works if you have independen header and body schemas
> is that the header schema has a set of promoted properties. Then you write
> the values for this properties into the context of the body message, and
> then the flat file assembler recreates the header when sending the body out
> of these properties.
>
> If this is not feasable, then you'll need to create a flat file schema that
> contains both header fields and body fields (this should always be possible
> in general) and create that directly from your orchestration (maybe with a
> transform), then have the assembler simply convert the entire message into
> its flat file representation.
>
>
> --
> Tomas Restrepo
> tomasr@xxxxxxxx
> http://www.winterdom.com/
>
>
>

in fact i'm afraid i didn't understand what you explain earlier in the first
solution.
the second solution works fine but this is not a nice tip cause i duplicate
my schema.

have you an simple example about your first solution ?

Thx

Yoann
.



Relevant Pages

  • RE: Flat file ASSEMBLER example
    ... I've created flat file schemas with header, body, and footer records. ... Add a New Item and select schema. ...
    (microsoft.public.biztalk.general)
  • Re: Flat file XSDs
    ... Root delimiter PostFix Hex "0x0D 0x0A" ... I have created a schema that will parse your sample data. ... line into the header. ... wholely unsuited to import by BizTalk Flat File Schema Wizard. ...
    (microsoft.public.biztalk.general)
  • Re: SSIS: ET flat text file to multi-level hierachal XML.
    ... intensively for flat file parsing and extraction and have multiple ... The report has multiple headers, ... header, multiple types of details having different detail columns, and some ... Then it'll go to the next step to extract all detail lines. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS: ET flat text file to multi-level hierachal XML.
    ... intensively for flat file parsing and extraction and have multiple ... The report has multiple headers, ... header, multiple types of details having different detail columns, and some ... Then it'll go to the next step to extract all detail lines. ...
    (microsoft.public.sqlserver.dts)
  • Re: Header Question - round 2... nobody responded
    ... I thought the flat file assembler would deal with headers as well (but I ... Is it possible that you want to have a multipart message (with both header ... body schema that the right thing will hapen? ... >> schema (for the output document). ...
    (microsoft.public.biztalk.general)

Loading