Stuart Padley, a Test Lead here in the SQL Server Engine team, posts about loading XML documents using a SQLCLR User Defined Function. It's good stuff and demonstrates an interesting way to overcome one shortcoming of OPENROWSET.