Hello
I need help how to store XML data from a website to my SQL server. I am planning to create a DTS package and schedule a task to execute the DTS package. But I am not quite sure how to achieve this task, ie how can I copy the XML files and parse the data. The URL contains several XML files and 24 files each day. IS it best that I store the the individual XML files on our server and then parse the XML data? I am guessing that this is better to code in VBScript as part of DTS. Another question how do I loop thru the XML files to validate that I have a copy already on the server?
Here's the site where I want to copy the xml files:
Hope someone can help me.
Many thanks,
Mary
I need help how to store XML data from a website to my SQL server. I am planning to create a DTS package and schedule a task to execute the DTS package. But I am not quite sure how to achieve this task, ie how can I copy the XML files and parse the data. The URL contains several XML files and 24 files each day. IS it best that I store the the individual XML files on our server and then parse the XML data? I am guessing that this is better to code in VBScript as part of DTS. Another question how do I loop thru the XML files to validate that I have a copy already on the server?
Here's the site where I want to copy the xml files:
Hope someone can help me.
Many thanks,
Mary