|
| Hi All,
I have a flat file need to convert it to xml in Biztalk 2004.
i am using a receive pipeline with flat file dissambler.
Problem is my mapping of flat file to xml is not working properly.The
out
put XML document is not what i am expecting.
flat file structure us below.It's basically tab delimited file.
val1 val2 val3
val4 val5 val6
so i defined a schema as
<Records>
<Record @Column1 @Column2 @Column3 >
</Records>
follwing are the only properties i have set
For 'Records' node ==>
Child delimiter : 0x0D 0x0A
Child delimiter Type : Hexadecimal
Child Order : PostFix
For 'Record' node ==>
Child delimiter : 0x09 (This is because in flat file each column is
separated by TAB)
Child delimiter Type : Hexadecimal
Child Order : Default
i was expecting one out put document like.
<Records>
<Record Column1='val1' Column2='val2' Column3='val3' />
<Record Column1='val4' Column2='val5' Column3='val6' />
</Records>
but insetad what is generated in the out put folder is 6(Probably
something to do with the six values i have given in the flat file)
different documents with the message ID.
each docuemnt looks something like this .
<?xml version="1.0" encoding="utf-8"?><Record Column1="va" Column2="l"
Column3="1 " xmlns="http://Import.ImportGenericSchema"></Record>
Thanks for any help
-siddharth
|
|