Just a last question, I can see how this will work when the XML gets transformed into 1 table.

If the record consists out of 80 odd tables, I will have to run the same processing script for each block of data and output each element to its corresponding table.

Would you advise to perhaps use XML Serialization, then exporting each element to a flat file with all the PK/FK's included and then use a flat text source to import each.

I am just worried about the overhead of running the XML process for each element, or will this be a non-issue?