Hi

I have the vbscript below in my dts package and xml schema, where I specify
which sql table field the data would go into - whilst I don't get any errors
- there's no data going into the table - it's completely empty - any ideas?


VB Script Active X

Function Main()
Set objBulkLoad =
CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
objBulkLoad.ConnectionString = "provider=SQLOLEDB;data
source=localhost;database=myproj; integrated security=SSPI"
objBulkLoad.ErrorLogFile = "c:\error.log"
objBulkLoad.Execute "c:\EAF1NL.xsd", "c:\EAF1NL.xml"
Set objBulkLoad = Nothing
Main = DTSTaskExecResult_Success
End Function




schema

<?xml version="1.0" encoding="utf-8"?>
<xsd:schema id="EAF1NL" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:element name="NL" type="NLF" sql:relation="DailyFileRecords" />
<xsd:complexType name="NLF">
<xsd:sequence>
<xsd:element minOccurs="1" maxOccurs="1" name="HDR" type="Header"
sql:is-constant="1" />
<xsd:element minOccurs="0" maxOccurs="unbounded" name="REC"
type="Record" sql:is-constant="1" />
<xsd:element minOccurs="1" maxOccurs="1" name="TRL" type="Trailer"
sql:is-constant="1" />
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Header">
<xsd:sequence>
<xsd:element minOccurs="1" maxOccurs="1" name="VER" sql:is-constant="1">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="FN" sql:field="FN"
sql:datatype="varchar(40)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="32" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="DATE" type="xsd:date"
sql:field="DATE" sql:datatype="datetime" />
<xsd:element minOccurs="1" maxOccurs="1" name="FTYPE"
type="xsd:string" sql:field="FTYPE" sql:datatype="int" />
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Record">
<xsd:sequence>
<xsd:element minOccurs="1" maxOccurs="1" name="LICENCE_NO"
type="licence" sql:is-constant="1"/>
<xsd:element minOccurs="1" maxOccurs="1" name="LICENSEE_FORENAME"
sql:field="LICENSEE_FORENAME" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="LICENSEE_SURNAME"
sql:field="LICENSEE_SURNAME" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="LICENSEE_ADDRESS"
type="pafaddress" sql:is-constant="1" />
<xsd:element minOccurs="1" maxOccurs="1" name="GENDER"
sql:field="GENDER" sql:datatype="varchar(6)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="6" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="DOB" type="xsd:date"
sql:field="DOB" sql:datatype="datetime"/>
<xsd:element minOccurs="0" maxOccurs="1" name="SENIOR_ID"
sql:field="SENIOR_ID" sql:datatype="varchar(25)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="25" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="DISABLED_ID"
sql:field="DISABLED_ID" sql:datatype="varchar(13)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="13" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="EMAIL"
sql:field="EMAIL" sql:datatype="varchar(50)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="ETHNIC_ORIGIN"
sql:field="ETHNIC_ORIGIN" sql:datatype="varchar(20)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="20" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="PREF_POST"
sql:field="PREF_POST" sql:datatype="char" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="PREF_EMAIL"
sql:field="PREF_EMAIL" sql:datatype="char" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="PREF_SMS"
sql:field="PREF_SMS" sql:datatype="char" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="MOBILE"
sql:field="MOBILE" sql:datatype="varchar(15)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="15" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="LICENCE_CATEGORY"
sql:field="LICENCE_CATEGORY" sql:datatype="varchar(36)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="36" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="LICENCE_TYPE"
sql:field="LICENCE_TYPE" sql:datatype="varchar(19)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="19" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="START_DATE"
type="xsd:date" sql:field="START_DATE" sql:datatype="datetime" />
<xsd:element minOccurs="0" maxOccurs="1" name="START_TIME"
type="xsd:date" sql:field="START_TIME" sql:datatype="datetime"/>
<xsd:element minOccurs="1" maxOccurs="1" name="CHANNEL_ID"
sql:field="CHANNEL_ID" sql:datatype="varchar(7)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="7" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="SERIAL_NO"
sql:field="SERIAL_NO" sql:datatype="varchar(12)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="12" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="AMOUNT"
type="xsd:double" sql:field="AMOUNT" sql:datatype="float" />
<xsd:element minOccurs="1" maxOccurs="1" name="MOPEX" type="xsd:byte"
sql:field="MOPEX" sql:datatype="int" />
<xsd:element minOccurs="1" maxOccurs="1" name="SYSTEM_DATE"
type="xsd:date" sql:field="SYSTEM_DATE" sql:datatype="datetime" />
<xsd:element minOccurs="1" maxOccurs="1" name="SYSTEM_TIME"
type="xsd:date" sql:field="SYSTEM_TIME" sql:datatype="datetime" />
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="licence">
<xsd:sequence>
<xsd:element minOccurs="1" maxOccurs="1" name="IIN" sql:field="IIN"
sql:datatype="varchar(10)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:minLength value="8" />
<xsd:maxLength value="8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="CRN" sql:field="CRN"
sql:datatype="varchar(10)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:minLength value="9" />
<xsd:maxLength value="9" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="LUHN" sql:field="LUHN"
sql:datatype="varchar(10)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:minLength value="1" />
<xsd:maxLength value="1" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="pafaddress">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="Result" type="xsd:byte"
sql:field="Result" sql:datatype="int" />
<xsd:element minOccurs="0" maxOccurs="1" name="QueryType"
type="xsd:byte" sql:field="QueryType" sql:datatype="int" />
<xsd:element minOccurs="0" maxOccurs="1" name="ErrorCode"
sql:field="ErrorCode" sql:datatype="varchar(21)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Org" sql:field="Org"
sql:datatype="varchar(122)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="122" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="POBox"
sql:field="POBox" sql:datatype="varchar(13)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="13" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Subprem"
sql:datatype="varchar(30)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Buildname"
sql:field="Buildname" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Buildnum"
sql:field="Buildnum" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="4" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Depthoro"
sql:field="Depthoro" sql:datatype="varchar(81)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="81" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Thoro"
sql:field="Thoro" sql:datatype="varchar(81)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="81" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Deplocal"
sql:field="Deplocal" sql:datatype="varchar(35)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Local"
sql:field="Local" sql:datatype="varchar(35)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="35" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Town" sql:field="Town"
sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="County"
sql:field="County" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Postcode"
sql:field="Postcode" sql:datatype="varchar(8)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Premises"
sql:field="Premises" sql:datatype="varchar(21)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Address"
sql:field="Address" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="ContAddress"
sql:field="ContAddress" sql:datatype="varchar(21)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="TownCity"
sql:field="TownCity" sql:datatype="varchar(21)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="CountyReg"
sql:field="CountyReg" sql:datatype="varchar(21)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="PostcodeZip"
sql:field="PostcodeZip" sql:datatype="varchar(16)">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="16" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="0" maxOccurs="1" name="Country"
sql:field="Country" sql:datatype="varchar(21)" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="21" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="Trailer">
<xsd:sequence>
<xsd:element minOccurs="1" maxOccurs="1" name="VER"
sql:is-constant="1" >
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element minOccurs="1" maxOccurs="1" name="recordno"
type="xsd:long" sql:field="recordno" sql:datatype="int" />
</xsd:sequence>
</xsd:complexType>
</xsd:schema>