I have an XML document that is loaded into a column of a table of the XML data type. Is there any good examples showing how to insert using a store procedure and OpenXML into a parent tables with primary key and also into a child table with it's associated foreign key? Both the Parent and Child have relationships to lookup tables. The XML documents does not contain the foreign keys but the look up values instead. The look up values need to be found in order to get the key from the lookup table to be inserted into either the Parent or Child tables...
Besides OPENXML and a Store Procedure, is there any other Microsoft tool (SSIS?) or .NET class that can be used to map a XML document to relational tables to insert the contents of the XML file?