I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table. My next step would be to parse each xml for each record to retrieve some data out of each, but that will come later. I first need to be able to read the url. Right now all I get is null values.
Here is a sample of one record (there are about 5000 in the xml):