xmlwrite to multiple output files ?

[DaneRI]

hi,

Is it possible to create multiple files with a dynamically created filename in an xmlwrite using "for each" on an input file from a query..

[Support_Julie]

If you're asking if it's possible to create a generic project to write .xml files on the fly, you can't do that.

If, on the other hand, you have the XML format created, and you're reading a database file and parsing each record into a separate .xml file then giving each file a name based on something in the record, that you can do.

[DaneRI]

Ok. so for example. A query runs containing field a, b, and c within each of 3 records. b's value is 1 for the first record, 2 for the second and 3 for the third. I want to be able to create 3 dynamic filenames in an xmlwrite (1.xml, 2.xml, 3.xml). I am using "foreach" logic. I am looking for the syntax..

thanks,

DP

[DaneRI]

I got it...I used a set variable task, then used the variable in the filename.