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

1 comment
  • 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

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post