Bulk Loading XML into SQL Server 2005 using .NET

objBL.CheckConstraints = True  // Check for Database Constraints and throw appropriate errors
objBL.SGDropTables = True      // Drop Tables referenced in Schema prior to loading
objBL.SchemaGen = True         // Create the Database Schema, if it does not exist      

using System;
using System.IO;
using System.Collections;
using SQLXMLBULKLOADLib;
using System.Data.OleDb;
using System.Diagnostics;

namespace SQLXmlExample
{
    class Program
    {
        [STAThread]
        static void Main(string[] args)
        {
            string schema = string.Empty;
            string datafile = string.Empty;
            string connectionString = @"provider=SQLOLEDB;data source=localhost;database=SqlXmlDemo;Integrated Security=SSPI;";

            for (int i = 0; i < args.Length; i++)
            {
                switch (args[i].ToLower())
                {
                    case "-schema": 
                            schema = args[i + 1];
                            break;
                    case "-datafile": 
                            datafile = args[i + 1];
                            break;
                }                            
            }
            if (schema == string.Empty || datafile == string.Empty)
            {
                Console.WriteLine("Missing Schema or Data File.  Format: SqlXmlExample -datafile [filename] -schema [filename]");
                return;
            }

            Load(datafile, schema, connectionString);
        }

        static public void Load(string XMLFilename, string XMLMappingFilename, string ConnectionString)
        {
            SQLXMLBULKLOADLib.SQLXMLBulkLoadClass loader = new SQLXMLBULKLOADLib.SQLXMLBulkLoadClass();
            loader.CheckConstraints = true;
            loader.XMLFragment = true;
            loader.SchemaGen = true;
            loader.SGDropTables = false;
            loader.Transaction = false;
            loader.ConnectionString = ConnectionString;
            loader.Execute(XMLMappingFilename, XMLFilename);
        }
    }
}

Dim objBL 
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objBL.ConnectionString = "provider=SQLOLEDB;data source=localhost;database=SqlXmlDemo;Integrated Security=SSPI;"
objBL.ErrorLogFile = "C:\ImportSample\error.log"

objBL.CheckConstraints = True
objBL.XMLFragment = True
objBL.SchemaGen = True
objBL.SGDropTables = True

objBL.Execute "C:\ImportSample\MappingFile.xml", "C:\ImportSample\DataFile.xml"
Set objBL = Nothing

<?xml version="1.0" encoding="UTF-8" ?>
<Data>
    <Record>
        <TABLE_NM>CLIENTS</TABLE_NM>
        <ERR>0</ERR>
        <FIRST_NAME>John</FIRST_NAME>
        <LAST_NAME>Smith</LAST_NAME>
        <CITY>Houston</CITY>
        <STATE>TX</STATE>
        <ZIP>77082</ZIP>
        <DOB>1973-07-13</DOB>
    </Record>
  <Record>
        <TABLE_NM>PROSPECTS</TABLE_NM>
        <ERR>-1</ERR>
        <FIRST_NAME>James</FIRST_NAME>
        <LAST_NAME>Walton</LAST_NAME>
        <CITY>Dallas</CITY>
        <STATE>TX</STATE>
        <ZIP>77563</ZIP>
        <DOB>1965-01-15</DOB>
    </Record>
  <Record>
    <TABLE_NM>CLIENTS</TABLE_NM>
    <ERR>0</ERR>
    <FIRST_NAME>Jane</FIRST_NAME>
    <LAST_NAME>Doe</LAST_NAME>
    <CITY>Austin</CITY>
    <STATE>TX</STATE>
    <ZIP>77342</ZIP>
    <DOB>1961-12-31</DOB>
  </Record>
</Data>

<?xml version="1.0" ?>
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
        xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"
        xmlns:sql="urn:schemas-microsoft-com:xml-sql" >

   <ElementType name="TABLE_NM"        dt:type="string" />
   <ElementType name="ERR"            dt:type="int" />
   <ElementType name="FIRST_NAME"    dt:type="string" />
   <ElementType name="LAST_NAME"    dt:type="string" />
   <ElementType name="ADDRESS"        dt:type="string" />
   <ElementType name="CITY"            dt:type="string" />
   <ElementType name="STATE"        dt:type="string" sql:datatype="nvarchar(2)"/>
   <ElementType name="ZIP"            dt:type="string" />
   <ElementType name="DOB"            dt:type="date" />
   
   <ElementType name="ROOT"            sql:is-constant="1">
      <element type="Record" />
   </ElementType>

   <ElementType name="Record"       sql:relation="PERSON">
      <element type="TABLE_NM"        sql:field="TABLE_NM" />
      <element type="ERR"            sql:field="ERROR_ID" />
      <element type="FIRST_NAME"    sql:field="NAME_FIRST" />
      <element type="LAST_NAME"        sql:field="NAME_LAST" />
      <element type="ADDRESS"        sql:field="ADDRESS_LINE1" />
      <element type="CITY"            sql:field="CITY" />
      <element type="STATE"            sql:field="ST" />
      <element type="ZIP"            sql:field="ZIP" />
      <element type="DOB"            sql:field="BIRTH_DT" />
   </ElementType>

</Schema>