BizTalk Flat file parsing Unexpected end of stream while looking for:','
<p>I have a CSV file that needs to be disassembled into XML.</p>
<p>It's a normal looking CSV with a header for first row followed by repeating records. The rows are delimited by CR+LF and the columns are delimited by commas. It does contain lots of columns so rather than pasting here, I've added a link to the sample I'm using for testing: <a href="http://biztalkers.com/stackoverflow/ff-dis/Init4PO.csv" rel="nofollow noreferrer">Input CSV file</a>. A copy of the flat-file XSD can be found here: <a href="http://biztalkers.com/stackoverflow/ff-dis/PurchaseOrder_FF.xsd" rel="nofollow noreferrer">Flat file schema</a></p>
<p>Within visual studio, I can right-click the schema, select &quot;Validate Instance&quot; and this works file, producing the following xml document:<a href="http://biztalkers.com/stackoverflow/ff-dis/PurchaseOrder_FF_output.xml" rel="nofollow noreferrer">XML document</a></p>
<p>I've created a receive pipeline, into which I've added a flat-file disassemble component. The DocumentSpecName property has been set to the strong name for the flat file schema.</p>
<p>My problem is, when the sample CSV is processed by the pipeline, I get the following error in the event log:</p>
<p><em>Reason: Unexpected end of stream while looking for:
','
The current definition being parsed is PO. The stream offset where the error occured is 2018. The line number where the error occured is 4. The column where the error occured is 0.</em></p>
<p>Can anyone see where I went wrong?</p>