I fairly new using XML data. I need to import the attached xml data into a SQL server database. I want to store the info it 2 tables: an Orders table that will stored the all the orders information (including customer name, billing, and shipping info) and a Products one that will store the products for each order.
In this sample XML, there are 3 orders. The first one has 2 products, the second one has 1 and the third one has 3.
The main problem is that I have no idea how to make the each data part to go into their respective table.
I've tried to create a schema for this XLS in Visual Studio 2003, but I got this error:
Failed to create a schema for this data file because:
Although this XML document is well formed, it contains structure that Data View canno Display.
The same table (NameParts) cannot be the child table in two nested relations.
Any help will be tremendously appreciated it.