Hi,

First of all, I'm a total newbie with MS SQL Server 2000 und also with XML.
What I want to do is this:
Make a XML connection from a SQL server 2000 with Transact-SQL to a
different DB server which will return a large XML result file. This XML
result file needs to be inserted into my DB.
Is there a function in Transact-SQL which I can use to make a HTTP-Call or
XML-Call?
If there isn't any function, which will be the best method to get this large
XML result file?
Should I use OpenXML to parse and insert the XML file or is it better and
faster to use the bulk load method for large XML files?
Can someone give me an example how I can do this?

Thanks in advance,
Pascal Scandola

"Scand" <schgand (AT) travelwindow (DOT) ch> wrote

[snip]
There isn't one in SQL 2000; there is one in SQL 2005.

Use a DTS job. In the DTS job add an ActiveX script that connects and
downloads the XML file. Then insert the XML into SQL Server using OpenXML.

For large XML files (which are only inserts) the bulk load method is faster.
However, if you use the bulkload method you will have to do the entire
import from script.

I don't have one currently but I will try to add on to the sqlxml.org site
since this is a pretty common request. Email me in a couple days if I
haven't posted it (using the email address on this post).

--
Bryant