Would this be easier in SQL 2005??
>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!
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.