Hey guys, I would like get my hands dirty with xml as early as possible. It might be our future way to grab data from vendor. Ok, here it is. The vendor has a website that subscribers can POST via http or https and it returns an xml report. What I was thinking is to interface to that so whenever a package(might be a DTS package) is executed, a) it will connect to the webserver b) POST submit input data c) retrieve XML output d) parse XML output e) populate a local table using the XML output So what are the ways I can do this? Can you give me guys things I can try out here? Any inputs are greatly appreciated. Thank you very much, Virt
I found a link sent by Satya on the other thread. It's cool http://www.perfectxml.com/articles/xml/importxmlsql.asp
