SQLTeam.com | Weblogs | Forums

Dynamic Table Creation based on Document Type Definition of XML


Good Morning Techie,

May any one share your expertise .

i have an XML document (1GB Size) with a Document Type Definition. both the file located in the standard fixed path

i need to load the data to sql table, but the challenge is the table structure must be created during run time depends upon the .dtd file.

The .dtd file is keep on changing based on customer to customer

i am new to the xml, Please help me. i can provide xml and .dtd if its required.

Thanks a ton.