RE: 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 14:19:09 -0800

Do I need to use an Orchestration with this and include a flat file
disassembler to make this work ?

"Klundell" wrote:

> 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)
  • Error working with a csv flat file
    ... I am getting an error when I try to process a flat file through BizTalk. ... My schema looks like this. ... Child Delimiter 0x0D 0x0A, Child Delimiter Type Hexadecimal, Child Order ... 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: datset with child table in two nested relations
    ... It seems that your XML is not correctly formed. ... a child table A that is a child to one table B and another table C. ... Other thing that you can do is try to validate the XML file against ... the schema using command. ...
    (microsoft.public.dotnet.languages.csharp)