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 |
|
REpicurus
Starting Member
2 Posts |
 Posted - 2007-04-02 : 15:18:29
|
| Hey Everyone: I have an issue (opportunity).Our ASP (Channel Advisor) allows capability to automate retrieving checkout reports (sales) via XML. They have very good documentation as to how to create HTTPS strings to retrieve the data. The first problem is that I do not know XML very well at all.But I do know that SQL 2000 supports XML parsing. The second problem is that I can get the XML string to work, and manually download the XML output. However, how can I automate saving the output XML WITHOUT manual intervention? Is there a method using a scheduled job (DTS), etc., that I can use to pass the variable HTTPS string, and save the resultant XML output?(With minimal surgery or heartache.) Thanks in advance for any help / suggestions,R.EpicurusR.E. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-04-02 : 15:48:53
|
| Try this for startershttp://www.yukonxml.com/articles/sql2000xml/ |
 |
|
|
REpicurus
Starting Member
2 Posts |
|
|
|
|
|
XML Challenge (!)