Q: How can I import an XML file to SQL Server 2000?
A: There are several ways to import XML files to SQL Server. Here, we provide three of them:
Large-capacity load COM interface. To extract the object and attribute of a document to a relational table, the fastest way is to use the large-capacity loading COM interface provided by SQL Server 2000 Extensible Markup Language 3.0 Service Pack 1 (SQLXML 3.0 SP1. The large-capacity status COM interface is included in the free download of SQLXML 3.0 SP1.
Textcopy.exe command line utility. You can use textcopy.exe command line utility if you do not want to extract the contents and tokens of the document to the relationship table. Textcopy.exe is an excellent tool for moving text and image data types from a single server row or column to or from.
Data conversion service (DTS ). If the XML document is simple, you can use DTS to extract information to the table row by row. This method requires that you define an XML file as an input data source, define a database table as an output data source, and write an ActiveX script to parse character input in the "<" and ">" mode, to extract entities, attributes, and values.
-Microsoft SQL Server Development team
