Two things:
1. Set Child order on the Root node to be "PostFix"
2. Set MaxOccurs on Row node to "unbounded"

Greg

"Proteus Duxbury" <proteus.duxbury@paconsulting.com> wrote in message
news:8Yudnb55zMRnuc7cRVnyjw@giganews.com...
> Hi,
>
> I'm trying very hard to retrieve a very simple flat file (see attached
> CCAT_INPUT.txt). It has 6 rows of comma delimited data. Enclosed is my
> attempt at a flat file schema although I'm sure it is wrong. Bellow is the
> message I get back from HAT. Could someone please take a look at my Schema
> and tell me where I am going wrong, or rewrite it for me. As you can see
> it's very basic.
>
> Thanks in advance,
>
> Proteus.
>
> ---------
>
> There was a failure executing the receive pipeline:
"CJIP.Recieve_FLat_File"
> Source: "Flat file disassembler" Receive Location: "C:\CJIP\02. CJIP
> ETL\CJIP\CCAT INPUT\*.txt" Reason: Unexpected data found while looking
for:
> '\r\n'
> The current definition being parsed is CCAT. The stream offset where the
> error occured is 0.
>
>
>

[ Post a follow-up to this message ]