Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Biztalk
acce.forsuppliers
acce.hipaa
acce.hl7
acce.rosettanet
accelerator.finserv
admin
appintegration
framework
general
library
nonxml
orchestration
sdk
server
setup
tools
xlangs
xsharp
  
 
date: Fri, 19 May 2006 15:06:02 -0400,    group: microsoft.public.biztalk.nonxml        back       


Flat File to multiple XML   
Have a delimited flat file, all rows the same, say:
    xxx,vvv,ddd
    aaa,qqq,fff

Need to make each row a separate XML output file. Right now, all rows endup 
in the same XML file.
Any help appreciated.

-- 
BobL
date: Fri, 19 May 2006 15:06:02 -0400   author:   Bob

Re: Flat File to multiple XML   
Redefine your schema from
<file>
     <rows>
          <field1></field1>
          <field2></field2>
          <field3></field3>
    </rows>
</file>

to
<row>
     <field1></field1>
     <field2></field2>
     <field3></field3>
</row>

Eric
http://stottcreations.com/blog

"Bob"  wrote in message 
news:vIGdnc-PfJKMivPZnZ2dneKdnZydnZ2d@comcast.com...
> Have a delimited flat file, all rows the same, say:
>    xxx,vvv,ddd
>    aaa,qqq,fff
>
> Need to make each row a separate XML output file. Right now, all rows 
> endup in the same XML file.
> Any help appreciated.
>
> -- 
> BobL
>
date: Fri, 19 May 2006 16:22:46 -0700   author:   Eric Stott

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us