XML file import SQL Server 2000

Server|xml

Q: How can I import an XML file into SQL Server 2000?

A: There are several ways to import an XML file into SQL Server, offering 3 of them:

Bulk load COM interface. If you need to extract the entity and attributes of a document into a relational table, the quickest way is to use the bulk load COM interface provided by SQL Server extensible Markup Language 3.0 Service Pack 1 (SQLXML 3.0 SP1). The large-capacity state COM interface is included in the SQLXML 3.0 SP1 free download.

Textcopy.exe Command line utility. If you do not want to extract the entity and attributes of a document into a relational table, you can use the Textcopy.exe command-line utility. Textcopy.exe is an excellent tool for moving text and image data types from a single server row or column into or out.

Data Transformation Services (DTS). If the XML document is simple, you can use DTS to extract the information line by row into the table. This approach 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 the character input of the "<" and ">" Methods to extract the entity, attribute, and its value.