Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sorengi
Starting Member
48 Posts |
 Posted - 2004-06-17 : 11:30:16
|
| I have a web api, which returns XML to an http request. I need to automate the insert of this XML into SQL server. I have already designed a procedure which used OPENXML to insert the XML packet, but I need to figure out a way to automate going to the page and retrieving the XML and calling the procedure. I lack experience on the application development side of SQL Server, and would appriciate any quick & simple ways to perform this. I am open as to platform & languages. The simpler the better...Thanks in advance for your ideas.Michael D. |
|
|
sorengi
Starting Member
48 Posts |
Posted - 2004-06-17 : 12:04:30
|
| . |
 |
|
|
sorengi
Starting Member
48 Posts |
Posted - 2004-06-21 : 16:39:06
|
| I was able to create an Active X script in a SQL Server Job, that automated this process, using Microsoft.XMLDOMMichael D. |
|
|
|
|
|
|
Automating XML from Web to SQL Server