Error working with a csv flat file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Klundell (Kris.Lundell_at_uuhsc.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 09:55:01 -0800

I am getting an error when I try to process a flat file through BizTalk.
My flat file looks like this.
Dow,John, 33
Dillan, Matt, 44
Henry, Jay, 22
With a carriage return line feed at the end of each line.
My schema looks like this.
<Schema>
     csvFlatFile_in_Schema
         Record_1
             field_1
             field_2
             field_3
Carriage Return Line fedd at the end

The properties set at the schema level are Schema Editor Extensions Flat
File Extension
The properties at the root node level are Structure Delimited.
Preserve Delimiter For Empty Data Yes
Child Delimiter 0x0D 0x0A, Child Delimiter Type Hexadecimal, Child Order
Postfix
Properties at the Record level are structure delimited, Min Occurs 1, Max
Occurs unbounded, Child Delimeter Type Character, Child Delimiter , Child
order Infix
When I validate my schema it validates fine. When I Validate my schema
instance it validates fine. Here is the sample file of my validated instance.

<csvflatFile_in_Schema
xmlns="http://firstCSVFlatFileProj.csvflatFile_in_Schema">
- <Record_1 xmlns="">
  <Field_1>Dow</Field_1>
  <Field_2>John</Field_2>
  <Field_3>33</Field_3>
  </Record_1>
- <Record_1 xmlns="">
  <Field_1>Dillan</Field_1>
  <Field_2>Matt</Field_2>
  <Field_3>44</Field_3>
  </Record_1>
- <Record_1 xmlns="">
  <Field_1>Henry</Field_1>
  <Field_2>Jay</Field_2>
  <Field_3>22</Field_3>
  </Record_1>
  </csvflatFile_in_Schema>

However, when I build a map and deploy the solution and then attach the map
to the send port and test it I don't get the out put file. When I go to hat I
get the following error.
The data at the root level is invalid Line 1 Position 1.
In the event viewer I get the following error.

There was a failure executing the send pipeline DefaultPipelines.XML Transmit
The data at the root level is invalid. Line 1, position 1.

What is the cause of this error ?
Thanks for any help.

Kris.

Relevant Pages

  • Re: Validating Optional Segments in FLatFile
    ... So when i get this kind of input file,When i am trying to validate against the schema, only segment 1 is recognised in the message and only Segment1 is getting populated in the validated output. ... I came across an issue while dealing with the flat file. ... Ok so from there I specify that all the ChildElements are optional ...
    (microsoft.public.biztalk.general)
  • Validating Optional Segments in FLatFile
    ... So when i get this kind of input file,When i am trying to validate against the schema, only segment 1 is recognised in the message and only Segment1 is getting populated in the validated output. ... I came across an issue while dealing with the flat file. ... Ok so from there I specify that all the ChildElements are optional ...
    (microsoft.public.biztalk.general)
  • RE: Error working with a csv flat file
    ... Do I need to use an Orchestration with this and include a flat file ... > The properties set at the schema level are Schema Editor Extensions Flat ... > Occurs unbounded, Child Delimeter Type Character, Child Delimiter, Child ... > When I validate my schema it validates fine. ...
    (microsoft.public.biztalk.general)
  • Re: RE: root element missing
    ... Can you post your flat file and schema? ... file is parsing, but when it tries to validate the generated XML, the ... expected root element is not found. ... The crazy thing is I can generate a flat file instance ...
    (microsoft.public.biztalk.general)
  • RE: Creating Schema for Flat File Disassembler
    ... I restructured you schema a bit and it will now parse your input data. ... main problem with your original schema was setting the positional offset ... Creating Schema for Flat File Disassembler ...
    (microsoft.public.biztalk.general)