Could someone give me an example of how I might be able to import an XML Doc that has this structure? I currently use this structure when Exporting / Importing data from any table in my DB. It's simple and understandable. Sometimes, this file can be about 50MB though. How would that be possible using a Stored Proc?

<DATASOURCE Name="Users">

<ROW>

<COLUMN Name="ID"><![CDATA[1]]></COLUMN>

<COLUMN Name="FirstName"><![CDATA[George]]></COLUMN>

<COLUMN Name="LastName"><![CDATA[Wilson]]></COLUMN>

</ROW>

<ROW>

<COLUMN Name="ID"><![CDATA[2]]></COLUMN>

<COLUMN Name="FirstName"><![CDATA[Martha]]></COLUMN>

<COLUMN Name="LastName"><![CDATA[Wilson]]></COLUMN>

</ROW>

</DATASOURCE>