Hello,

I received an XML export of a database from a program called Reference
Manager. It is a single table.

I need to import it to SQL Server 2000. The DTS wizard has no option to
accept xml in the drop down. How would I go about importing it?

The Wizard does not have those options.

To top it off, I am using the client tools.

Suggestions?

Thanks,

V

MS don't supply an OLE-DB XML provider, but Merant/Data Direct have one.

MS do supply the SQLXML web release for SQL 2000 that includes the XML
Bulk Load tool. This can be used via a Script Task, something like this, but
this is incomplete I know-

Function XMLBulkLoad(xmlDom, sXSDFile, sErrLog)
Dim oXMLBulkLoad

' Configure Bulk Insert and execute
Set oXMLBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
oXMLBulkLoad.ConnectionString =
GetConnectionString(DTSGlobalVariables.Parent.Conn ections("Lite"))
oXMLBulkLoad.ErrorLogFile = sErrLog
oXMLBulkLoad.CheckConstraints = True
oXMLBulkLoad.SchemaGen = False
oXMLBulkLoad.SGDropTables = False
oXMLBulkLoad.KeepIdentity = False
oXMLBulkLoad.Execute sXSDFile, xmlDom

Set oXMLBulkLoad = Nothing
End Function

This is documented in the SQLXML stuff.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Veep" <Veep (AT) discussions (DOT) microsoft.com> wrote