Koen Verbeeck (12/20/2012)
A very elaborate workaround:you could use the Export column to export each location to a seperate flat file (you'd need to combine all the data columns you need and then convert them to DT_TEXT). The name of the flat file will contain the name of the city.
After that, you can use a for each loop to loop over your newly generated flat files and do whatever you want to do with the data.
But a flat file is the input to this problem.
Have you somehow guessed what the output requirement is? Hats off if you have 🙂
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.