SQL Server 2000 XML Integration

HI,

at present I import an XML doc into Access using VBA. The XML is generated from a url on a 3rd party website.

I have upsized to SQL Server 2000 and wish to import this document still but I'm unsure how to do it or where to start looking. All the info I've found to date involves allowing you to send queries to SQL server over http, by setting up a virtual directory in IIS or by importing a saved xml document ... not one that is obtained from a url.

Can someone help me please?

M3ckon

MS SQL 2000 allows you to export query results to XML. Or as you have also found allows HTTP access. It does NOT allow you to import XML data with out parsing it thorugh some other source first, such as your VB app that you mentioned...

Thanks for the reply ... however, I've managed to get this working now

I created a DTS package that accessed an ActiveX scripting component and I call this DTS package using an sproc.

I was thinking about writing an article on this as my method is relatively straightforward, yet all the web sites I found detailed very complex methods of doing this

M3ckon

Hi,
I used sproc but it did not generate the first line of the xml:
<?xml version="1.0" encoding="ISO-8859-9" ?>
what did i do wrong, is there anybody that can help?

and also i do not know how execute that package....

and also is there a way that i can write the output into a txt.....

Thanks for the reply ... however, I've managed to get this working now

I created a DTS package that accessed an ActiveX scripting component and I call this DTS package using an sproc.

I was thinking about writing an article on this as my method is relatively straightforward, yet all the web sites I found detailed very complex methods of doing this

M3ckon

Can you say that a bit clearer please ans I'll try to help

M3ckon