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

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

android - Robolectric "INTERNET permission is required" -

java - Android raising EPERM (Operation not permitted) when attempting to send UDP packet after network connection -