I have a new source of data I need to load into a data warehouse. It's in XML.
I've loaded XML data before using an activeX script, but it was very time consuming to set up. I needed to create a schema and map each node to a database table and column. I'm thinking there has to be a better way. I'm interested to hear what others are doing to solve this integration issue.