SQL Server Performance

retrieving xml data

Discussion in 'General Developer Questions' started by v1rtu0s1ty, May 24, 2005.

  1. v1rtu0s1ty New Member

    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,

  2. v1rtu0s1ty New Member

Share This Page