Hi all,
I have given to load this one XML file via DI to some target table. To me the file looks quite messy and I was unable to load it.
Just want expert opnion for the same, if this file can be loaded.
Heres the sample file:
==============================================================================================
<s:Schema id=‘RowsetSchema’>
<s:ElementType name=‘row’ content=‘eltOnly’ rs:updatable=‘true’>
<s:AttributeType name=‘ATCCode’ rs:number=‘1’ rs:writeunknown=‘true’ rs:basecatalog=‘ATC’ rs:basetable=’#t1’
rs:basecolumn=‘ATCCode’>
<s:datatype dt:type=‘string’ rs:dbtype=‘str’ dt:maxLength=‘10’ rs:maybenull=‘false’/>
</s:AttributeType>
<s:AttributeType name=‘Name’ rs:number=‘2’ rs:nullable=‘true’ rs:writeunknown=‘true’ rs:basecatalog=‘ATC’ rs:basetable=’#t1’
rs:basecolumn=‘Name’>
<s:datatype dt:type=‘string’ rs:dbtype=‘str’ dt:maxLength=‘255’/>
</s:AttributeType>
<s:AttributeType name=‘Comment’ rs:number=‘3’ rs:nullable=‘true’ rs:writeunknown=‘true’ rs:basecatalog=‘ATC’
rs:basetable=’#t1’ rs:basecolumn=‘Comment’>
<s:datatype dt:type=‘string’ rs:dbtype=‘str’ dt:maxLength=‘255’/>
</s:AttributeType>
<s:extends type=‘rs:rowbase’/>
</s:ElementType>
</s:Schema>
rs:data
<z:row ATCCode=‘A’ Name=‘ATT’/>
<z:row ATCCode=‘A01’ Name=‘TMOBY’/>
<z:row ATCCode=‘A01A’ Name=‘CIRCULAR’/>
<z:row ATCCode=‘V20’ Name=‘SPRINT’/>
</rs:data>
The column that I am interested is ATCCODE and NAME
Thanks,
data_guy 
(BOB member since 2006-08-19)