How To Load Huge (but Simple) Hierarchical Xml File Into An Sql Table

I have a very large (2.5GB, 55 million node) XML file with the following format: A link

Solution 1:

I would use the XML Bulk Load. This is a nice approach because it doesn't read in the entire document at once, it streams it. It's also quite fast and keeps to your requirement of sticking with an SQL Server based tool.

Solution 2:

Take a look at Oslo/M.