Home Page › Forums › BizTalk 2004 – BizTalk 2010 › newbie question: strip off trailer of positional flat file › newbie question: strip off trailer of positional flat file
Hi,
I am newbie in using BizTalk 2006. I am having issie in receiving a simple positional flat file and strip of the trailer from it for further process.
The positional flat file format looks like below. Each field has trailing space, if that field value doesn’t take all the length, except the last field which may end with whatever length of data it contains(even less than the predefined field length).
FieldA1 FieldA2 FieldA3
FieldB1 FieldB2 FieldB3
FieldC1 FieldC2 FieldC3
EOF
I defined body/trailer schema and flat file receive pipeline by following Stephen Thomas’s BizTalk 2004 sample, except my case has trailer but no header. However, the parser seems having problem to parse the Body and Trailer schema, and trying to look for further data. From the following error message, it seems the parser keep looking for third line of data, even though I only have single record and one trailer line.
Thanks in advance for your help,
MJ
—————–
There was a failure executing the receive pipeline: \”ABC.BizTalk.Demo.pipeline, ABC.BizTalk.Demo, Version=1.0.0.0, Culture=neutral, PublicKeyToken=14e1e338d558d117\” Source: \”Flat file disassembler\” Receive Port: \”TestInboundBatch\” URI: \”C:\\ABC\\TestInboundBatch\\*.*.cms*\” Reason: Unexpected end of stream while looking for:
Positional data (length is 14)
The current definition being parsed is Record. The stream offset where the error occured is 240. The line number where the error occured is 3. The column where the error occured is 0.
—————–