Phil Parkin (12/20/2012)
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 🙂
Yes, but now he has seperate flat files for each location 🙂
I guessed he would like to insert the different locations in different tables. That should work with my scenario.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP