Importing XML into SQL Server

[rockyroad]

Hello,

Does anyone know if it is possible to parse through and import the STRUCTURE of an XML document and DTD and create equivillent SQLServer dtabase tables?

Scenario: I am presented with an XML document and a DTD for a product. I want to put the data in SQLServer to take atvantage of Indexing etc, so that web based application can query this data more efficiently. I do have a data model document, but the structure is very complex.

Is it possible then to import the structure on the fly, through a script or DTS, without having to manually write out the tables in a CREATE Table? Is there a way to parse through the inherit structure of the XML and DTD and create the SQL server tables based on this structure?

THANKS!!!!!!

 

[JontyMC]

Use OPENXML:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/CoolestFeatures.asp

Jon

"I don't regret this, but I both rue and lament it.