I'm on a datawarehouse (DW) project actually and i need your help !
I got an historic of my transactions in an xml format.
I'd like to export these transactions in the tables of my DW.
First there is a mismatch between my xml structure and the structure of my transaction table.
You'll find the details in the attachements.
I found an example of script on the web : http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx
This script works but i don't know how to adapt it to my transaction table.
I want to take the details of the transactions from the xml files and put them in the transaction table.
Can you help me ?