Since the release of SQL Server 2000, processing XML data has been a topic of discussion among database administrators. It is often used when a front-end application passes an XML document to a stored procedure within an input parameter. Sometimes, however, you encounter a folder containing a set of XML files that needs to be loaded into the database and then processed into SQL Server tables. This is more difficult, and documentation on how to do so is sparse.

You can use several techniques, most of which are quite complex. I have used SQL Server Integration Services (SSIS),