asked
Dynamic Table Creation based on Document Type Definition of XML
I have an XML document (1 GB in size) with a Document Type Definition. I need to load the data into an sql table, but the challenge is the table structure must be created during runtime, and it depends upon the .dtd file. The .dtd file changes from customer to customer. I am new to XML. I can provide the XML and .dtd if its required. Thanks a ton.
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
There is no simple, magic, way to do this. In order to accomplish what you're after, you need to understand the dtd files and how they relate to the required SQL table(s). Only after you have a reasonable grasp on this can you expect to generate tables on the fly from your document.
From ssis perspective you could try using - xml source, xml task and if they dont do justice , a script component/task to write your customized code. Please attach the xml and dtd files is possible.
SSIS cannot automatically adjust for XML files for which the structure changes.
20 People are following this question.
