Since you have to manipulate data, what you can do ( which I did too) TRANSFORM your XML files into smaller xml files and during transformation manipulate your data. Than use OPENXML to load your data directly or even can be BULKLOAD.