BizTalk Flat file parsing Unexpected end of stream while looking for:',' -
i have csv file needs disassembled xml.
it's normal looking csv header first row followed repeating records. rows delimited cr+lf , columns delimited commas. contain lots of columns rather pasting here, i've added link sample i'm using testing: input csv file. copy of flat-file xsd can found here: flat file schema
within visual studio, can right-click schema, select "validate instance" , works file, producing following xml document:xml document
i've created receive pipeline, i've added flat-file disassemble component. documentspecname property has been set strong name flat file schema.
my problem is, when sample csv processed pipeline, following error in event log:
reason: unexpected end of stream while looking for: ',' current definition being parsed po. stream offset error occured 2018. line number error occured 4. column error occured 0.
can see went wrong?
i able working removing header node schema. set "headerspecname" property of receive pipeline point same schema "documentspecname" , ensured "preserveheader" property set false (default).
i realise biztalk docs suggest creation of separate schema header , body don't see value in if structure of header , body records identical.
i have created many ff schemas in past header node. prefer have because better describes structure of ff disassembled. standard technique omit map record canonical schema after disassembly.
i can't explain why disassembly failing on occasion time pressing i'd better move on.
Comments
Post a Comment