Free XML ODBC Drivers?

Hi to everybody, I am a newbie who is trying to import data from and
XML file into a table in SQL Server 2000. I've reading all the MS
information about the SQLXML's 'XML Bulk Load' and it seems that this
feature can only be accesible through the 'DTS Designer' in the
Enterprise Manager.
I've tried successfully to import the XML using a DataDirect ODBC
driver. Unfortunately it's not free and its evalutation version
doesn't long too much...
So, I'd like to ask the community if somebody knows and ODBC driver
that could be used to import XML into SQL Server 2000 and that would
be free/open source.
Also, since it seems that XML Bulk Load can only be accessible through
the 'DTS Designer' I'd like to know if I'm wrong and where I can find
the info to make this useful feature work in the import/export wizard.
Greetings,
DavidI didn't think SQL XML Bulk Load had any UI at all. I thought it was just a
COM object. Well there is a COM object as I use this from VBScript daily.
This script happens to be inside an ActiveX Script Task, but that is just my
implementation.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.com...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David|||Dear David, I'm newbie too...and I'm improving in your same problem...
Can you indicate me the DataDirect driver you have downloaded and a little
example of DTS you have developped to import the xml file?
Best regards
Bruno Stefanutti
"David Grant" wrote:

> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
>|||See below.
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.com...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
This is incorrect. The SQLXML XML BulkLoad component is accessible as a COM
object.

> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
SQLXML is not an ODBC driver but internally uses an OLEDB provider.

> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
Check out http://msdn.microsoft.com/sqlxml.

> Greetings,
> David