Below is my vbs script, table, schema, and xml data. When I run the vb
script I don't get any errors OR records. I used VS.Net to create the schema
and I added the sql relation attribute to it. I thought that was enough, but
it does not work. Please any help would be appreciated!!!!!!

******vbs script**********
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload")

objBL.ConnectionString = "provider=SQLOLEDB;data source=localhost;user
id=sa;password=youwish"

objBL.KeepIdentity = False

objBL.Execute "C:\Temp\Schema.xsd", "C:\Temp\Data.xml"

set objBL=Nothing

msgbox "Done"

*****table*******

CREATE TABLE [KlebergImport] (
[RecNo] [int] IDENTITY (1, 1) NOT NULL ,
[ResidentId] [varchar] (30) NULL ,
[PersonalId] [varchar] (30) NULL ,
[LastName] [varchar] (50) NULL ,
[FirstName] [varchar] (50) NULL ,
[MiddleName] [varchar] (50) NULL ,
[Ssn] [varchar] (11) NULL ,
[Dob] [varchar] (20) NULL ,
[Gender] [varchar] (1) NULL ,
[BldgId] [varchar] (30) NULL ,
[PodId] [varchar] (30) NULL ,
[Bed] [varchar] (50) NULL ,
[ClassId] [varchar] (30) NULL ,
CONSTRAINT [Pk_KlebergImport_RecNo] PRIMARY KEY  CLUSTERED
(
  [RecNo]
)
)
GO

****schema****

<?xml version="1.0" ?>

<xs:schema id="VFPData" targetNamespace="http://tempuri.org/kleberg.xsd"
xmlns:mstns="http://tempuri.org/kleberg.xsd"

xmlns="http://tempuri.org/kleberg.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"

xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
attributeFormDefault="qualified" elementFormDefault="qualified">

<xs:element name="VFPData" msdata:IsDataSet="true"
msdata:EnforceConstraints="False">

<xs:complexType>

<xs:choice minOccurs="0">

<xs:element name="ftpcomm" sql:relation="KlebergImport">

<xs:complexType>

<xs:sequence>

<xs:element name="residentid" type="xs:string" minOccurs="0" />

<xs:element name="personalid" type="xs:string" minOccurs="0" />

<xs:element name="lastname" type="xs:string" minOccurs="0" />

<xs:element name="firstname" type="xs:string" minOccurs="0" />

<xs:element name="middlename" type="xs:string" minOccurs="0" />

<xs:element name="ssn" type="xs:string" minOccurs="0" />

<xs:element name="dob" type="xs:string" minOccurs="0" />

<xs:element name="gender" type="xs:string" minOccurs="0" />

<xs:element name="bldgid" type="xs:string" minOccurs="0" />

<xs:element name="podid" type="xs:string" minOccurs="0" />

<xs:element name="bed" type="xs:string" minOccurs="0" />

<xs:element name="classid" type="xs:string" minOccurs="0" />

<xs:element name="status" type="xs:string" minOccurs="0" />

<xs:element name="buildtime" type="xs:string" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>

****data*******

<?xml version="1.0" encoding="Windows-1252" standalone="yes" ?>

<VFPData xmlns="http://tempuri.org/kleberg.xsd">

<ftpcomm>

<residentid>242265</residentid>

<personalid>911213</personalid>

<lastname>VALLEJO</lastname>

<firstname>JUAN</firstname>

<middlename />

<ssn>386686964</ssn>

<dob>1958-10-20</dob>

<gender>M</gender>

<bldgid>SEC 1</bldgid>

<podid>1B</podid>

<bed>01</bed>

<classid>MED</classid>

<status>AJ</status>

<buildtime>2004-12-06T13:15:00</buildtime>

</ftpcomm>

<ftpcomm>

<residentid>241721</residentid>

<personalid>911426</personalid>

<lastname>VASQUEZ</lastname>

<firstname>MICHAEL</firstname>

<middlename>ROY</middlename>

<ssn>452290508</ssn>

<dob>1967-07-03</dob>

<gender>M</gender>

<bldgid>SEC 1</bldgid>

<podid>2E</podid>

<bed>01</bed>

<classid>MAX</classid>

<status>AJ</status>

<buildtime>2004-12-06T13:15:00</buildtime>

</ftpcomm>

<VFPData >

Thanks,

Jeff Langston

Cashless Systems

I'm not sure if you've just made a mistake when you posted the schema
or if the mistake is in your schema. The mistake is there should be a
space between these:

targetNamespace="http://tempuri.org/kleberg.xsd"xmlns:mstns="http://tempuri.org/kleber..."
xmlns:xs="http://www.w3.org/2001/XMLSchema"xmlns:msdata="urn:schemas-microsoft-..."

In both lines there is no space between the ending " and the beginning
xmlns they should read

targetNamespace="http://tempuri.org/kleberg.xsd"
xmlns:mstns="http://tempuri.org/kleber..."
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-..."

An easy way to validate that your schema is valid XML is to save it as
schema.xml and open it in IE.

Capture FOR XML output in a local string variable?
SQLXMLBulkLoad with VB .Net - No errors but data is not loading
generating XML to validated against the schema
XML files with bad characters
xsd annotations for xpath query