Import A Store Xml File Which Has Dtd Into Sql 2005

I am trying to import a store xml file which has dtd into sql. The file is 97,211 kb. I want to get the data and columns into sql 2005. So far I have tried this:


DECLARE @xml XML;

use yahoostore

CREATE TABLE Products(xmlCol XML)

INSERT INTO Products(XmlCol)

SELECT

CONVERT(XML, BulkColumn, 2)

FROM OPENROWSET (BULK 'C:databasexmldtdyahoostore.xml', SINGLE_BLOB)AS X

This creates the table and only one column which takes a while to open, but I do not see anything in it.

Could someone please help with this problem. I have used openrowset and openxml and I am getting no where.

Thanks
Dee