您应该看一看SQLXML批量加载它导入大型XML文件进行了优化。我的数千条记录成功地使用这种在过去和击败其他XML进口手了。

You should have a look at SQLXML Bulk Load which is optimized for importing large xml files. I've used this successfully in the past with thousands of records and beats other xml imports hands down.

http://msdn.microsoft.com/en-gb/library/ ms171878.aspx