Xml-file as datasource in an InMemory project.
I need to build an InMemory project having an xml-file as input. I have added an xml datasource but can not figure out, how to use it in an import query. An example would be very much appreciated. My input-file is similar to this:
0
Comments
Hi Ole,
I've created a small example based on a XML structure like this:
I connect to the XML file and uses a SQL like this with a Import task:
SELECT * FROM dvd
If you need actors, then use this:
SELECT * FROM actor
Does this help?
Best regards,
Jesper da Silva Endelt
Please sign in to leave a comment.