Get xml from DB (multiple rows) then using tExtractXML produce 1 row

[Anonymous]

Hi All,
I am trying to read xml from a db and dump the contents to csv or db. For example:
my query is select top 10 xml from xml table.
I want to generate 10 (or more) rows of data to csv.
I have created: 
tjDBCInput --<main> -- tExtractXMLField -- <main> -- tFileOutputDelimited 
However I am finding that 10 rows will be generated by DB component and passed onto XML component. The XML is passed correctly, but only 1 row will be generated by the XML component and saved into File component. (expecting 10 rows and 10 rows)
Can anyone please help? It's the same when I replaced file with tLogRow. (see screenshot below)



In addition, if I get this work, I want to extract more repeating elements out from the XML data, and output to a relational database, any tips?

Many Thanks,
Anthony

[Anonymous]

okay i have figured out my self, the tExtractXMLElement component had a limit property which was set to 1. I have updated to an arbitrary 1000 and it worked. The question is though how to get it to a variable amount based on the previous rows retrieved.