This is my sql table\[code\]CREATE TABLE Cust (OrderDate varchar(20), CustomerID int PRIMARY KEY, CompanyName varchar(20), City varchar(20)); CREATE TABLE CustOrder (OrderID int PRIMARY KEY, CustomerID int FOREIGN KEY REFERENCES Cust(CustomerID));\[/code\]This is my \[code\]sqlxml.xml\[/code\] file\[code\]<?xml version="1.0" encoding="utf-8" ?><ROOT> <OrderDate>10/12/2012</OrderDate> <Customers> <CustomerID>1111</CustomerID> <CompanyName>Sean Chai</CompanyName> <City>NY</City> <Order><OrderID>1</OrderID></Order> <Order><OrderID>2</OrderID></Order> </Customers> <Customers> <CustomerID>1112</CustomerID> <CompanyName>Tom Johnston</CompanyName> <City>LA</City> <Order><OrderID>3</OrderID></Order> </Customers> <Customers> <CustomerID>1113</CustomerID> <CompanyName>Institute of Art</CompanyName> <Order><OrderID>4</OrderID></Order> </Customers></ROOT>\[/code\]Below is the \[code\]sqlschema.xml\[/code\]\[code\]<?xml version="1.0" encoding="utf-8" ?><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:annotation> <xsd:appinfo> <sql:relationship name="CustCustOrder" parent="Cust" parent-key="CustomerID" child="CustOrder" child-key="CustomerID" /> </xsd:appinfo> </xsd:annotation> <xsd:element name="ROOT" sql:is-constant="1" > <xsd:complexType> <xsd:sequence> <xsd:element name="OrderDate" type="xsd:string" /> <xsd:element name="Customers" sql:relation="Cust" > <xsd:complexType> <xsd:sequence> <xsd:element name="CustomerID" type="xsd:integer" /> <xsd:element name="CompanyName" type="xsd:string" /> <xsd:element name="City" type="xsd:string" /> <xsd:element name="Order" sql:relation="CustOrder" sql:relationship="CustCustOrder"> <xsd:complexType> <xsd:sequence> <xsd:element name="OrderID" type="xsd:integer" /> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element></xsd:schema>\[/code\]This is my vbscript\[code\]Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")objBL.ConnectionString = "provider=SQLOLEDB.1;data source=MySQLServer;database=MyDatabase;uid=MyAccount;pwd=MyPassword"objBL.ErrorLogFile = "c:\error.log"objBL.Execute "c:\sqlschema.xml", "c:\sqlxml.xml"Set objBL = Nothing\[/code\]But I am getting an error\[quote\] Schema: cannot infer default mapping for 'OrderDate'. Neither it nor any of its ancestors defines a relation.\[/quote\]