XML as Datasource?

Checking to see if any of you have used XML as a datasource or have any clever ideas for my problem.

My client has been supplying CSV files which upload nicely with SQLServer DTS. Well, they have another system that is now going to output the data in XML files. The structure of the data is, of course, different and there is no easy way to use DTS to upload the file unless you write out the schema.

I found where it is possible to use the XML as a datasource with ASP but I'm not sure if it is going to be worth all the effort if there is an easier way.


Ideas?
 
Back
Top