Posted by Jack Vamvas on 05/10/07 09:37

Further to the process Plamen outlined , for step 1 , I used a HTTP file
downloader i.e Lynx, which allowed me to add a list of XML files.

If you are using SQL 2000 and OPENXML , you will have problems. If this is
the case , check http://www.quicksqlserver.com/2007/03/openxml_more_th.html

--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/sql

<a href="http://www.itjobfeed.com/sql"> sql it jobs</a>



<markjerz@googlemail.com> wrote in message
news:1178638239.766068.113510@p77g2000hsh.googlegroups.com...
> Hi,
>
> I have a problem which I don't entirely know how to tackle:
>
> Essentially, is it possible to query a web service (via http), using
> sql server 2000, and then import that data in to the database?
>
> I have seen many posts on openxml and sql servers bulk load facilities
> but nobody seems to mention whether you can open an http stream and
> read the xml in from there.
>
> Any help would be greatly appreciated.
>
> Thanks.
>

[Back to original message]