Check SQLXML for SQL Server 2000 at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp

>I have read the BOL for OPENXML, and the related topics. In every example I can find, the code uses a local variable set equal to the XML text. That is not efficient when regularly importing a large XML document.
>
>I have looked at the import types in DTS, and none of them specify XML source.
>
>What is the best way to import an XML document into a table? The document format may change over time.
>
>Assistance is greatly appriciated!