importing xml that has dtd into an sql 2005 table

Hello,

I am trying import the data and column names from an xml file into an sql
2005 table. This is what I have used.


DECLARE @xml XML;
CREATE TABLE Products(xmlCol XML)
INSERT Products
SELECT CONVERT(XML, BulkColumn, 2)
FROM OPENROWSET (BULK 'C:\database\xmldtd\yahoostore.xml', SINGLE_BLOB) AS
Products

This creates the table, and inserts one column which takes a long time to
open, but seems to be empty.

Can anyone give me any suggestions? The xml file has dtd which I used the
convert for, but how do I get the columns and information from those colums.
This is xml file 93.2 mb. Is it too large?

Thank you
Dee

How have you verified that the table is empty?

Regarding XML data size: 2GB is the limit.


ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/