Read XML from Web Server into SQL

[dogbody]

I have a sql script that reads an xml file from my hard drive, prepares it, and reads data from it. I'd like to be able to read the xml file from a web server rather than from my own pc. Anyone know the best way to do this?

 

[bigfoot]

I would use .net's dataset object to do it, then write the values with an insert statement. Does DTS have a way to read XML? I'll bet it does somewhere.

 

[dogbody]

Thanks, I don't think I was clear, I am trying to do get it done within the sql script so that I can just execute it in query analyser or osql. But I think I'll just use DTS and VBScript, thanks again