Pulling XML from Web Site and Storing in a Database
Posted on 2003-11-19
I going to attempt to get the department of Fish and Wildlife in my area to post some data in XML format on one of their web pages.
They currently post this information manually by having one of the clerks edit a static web page in a wysiwyg editor.
I can't imagine getting them to set up a web service, but I think I can at least get them to post a data island, or a plain .xml file with the data.
I would like to be able to automate the process where my server would contact thier server and pull that data, and then store it in my DB.
I am looking for a "best practice" type of application here.
I know there are ways to write an asp.net application and then schedule it to run say once a day, but I would suspect there would also be a way to do it within an MS SQL 2k stored procedure that was also scheduled to run periodically.
What is the best way to accomplish this task?