June 11, 2009 at 5:49 am
I have found much information about opening an xml document that is on disk (i.e. c:\my.xml). However I have not found how to open xml from an http provider such as http://myxml.somserver.com/givememy.xml. Any suggested reading? I basically want to consume xml data from the web then process it as if it were a file on my disk.
I have searched for about 20 minutes and I must not know a keyword as I am not finding anything.
Jimmy
"I'm still learning the things i thought i knew!"July 10, 2009 at 3:22 am
You could use SQL CLR to access a remote resource directly from the Database Engine, but sooner or later you might end up reinventing elements that are already available in SSIS.
Have you considered using a SQL Server Integration Services package for this?
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply