XML connection to a different DB server - 09-07-2004 , 04:16 AM
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
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,
Re: XML connection to a different DB server - 09-08-2004 , 10:58 AM
"Scand" <schgand (AT) travelwindow (DOT) ch> wrote
downloads the XML file. Then insert the XML into SQL Server using OpenXML.
However, if you use the bulkload method you will have to do the entire
import from script.
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).