Honestly, I'm used to using OpenRowset's Bulk option to pull XML files into an XML column in a single step. I haven't used OpenXML in years.
Once the XML is in a table in an XML column, I can have XML indexes on it and all that kind of thing. I've processed some fairly large files (multiple Mb per file) pretty quickly that way.
So, I can't really speak to how well OpenXML will work on this.
Another option I've used successfully is SSIS to import and normalize XML data. But I've only done that with fairly small files. Usually no more than about 100kb for the ASCII-format XML files.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon