BR><BR>The simple method would appear to be using SQL Server's SSIS Data Flow Task with XML as a source [edit: more specifically, using the XML Task]. However, the XML in question is backed by 8MB ...

or to span relational and XML sources. SQL/XML is another standard that uses declarative, portable queries to return XML by querying relational data. It's an extension of SQL that is part of ANSI/ISO ...