> Hard to tell from that. Have you been able to get the code to run just as
> VBScript, outside DTS? I'd start there.
>
> If it does run successfuly, you may need to look at what service account DTS
> runs under and what permissions it has.
>
> A _small_ amount of sample data and target table DDL might help too ... if
> you're really stuck.
>
> "jojo123" wrote:
>

>> 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?
>> I'm trying to load the data into a single table
>>
>>
>> VB Script :
>>
>> 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
>> ----------
>>
>> http://www.w3.org/2001/XMLSchema"
>> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
>>
>>
>>
>> >> sql:is-constant="1" />
>> >> type="Record" sql:is-constant="1" />
>> >> sql:is-constant="1" />
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> >> sql:datatype="varchar(40)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="DATE" sql:datatype="datetime" />
>> >> type="xsd:string" sql:field="FTYPE" sql:datatype="int" />
>>
>>
>>
>>
>> >> type="licence" sql:is-constant="1"/>
>> >> sql:field="LICENSEE_FORENAME" sql:datatype="varchar(21)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="LICENSEE_SURNAME" sql:datatype="varchar(21)" >
>>
>>
>>
>>
>>
>>
>> >> type="pafaddress" sql:is-constant="1" />
>> >> sql:field="GENDER" sql:datatype="varchar(6)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="DOB" sql:datatype="datetime"/>
>> >> sql:field="SENIOR_ID" sql:datatype="varchar(25)">
>>
>>
>>
>>
>>
>>
>> >> sql:field="DISABLED_ID" sql:datatype="varchar(13)">
>>
>>
>>
>>
>>
>>
>> >> sql:field="EMAIL" sql:datatype="varchar(50)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="ETHNIC_ORIGIN" sql:datatype="varchar(20)">
>>
>>
>>
>>
>>
>>
>> >> sql:field="PREF_POST" sql:datatype="char" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="PREF_EMAIL" sql:datatype="char" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="PREF_SMS" sql:datatype="char" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="MOBILE" sql:datatype="varchar(15)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="LICENCE_CATEGORY" sql:datatype="varchar(36)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="LICENCE_TYPE" sql:datatype="varchar(19)" >
>>
>>
>>
>>
>>
>>
>> >> type="xsd:date" sql:field="START_DATE" sql:datatype="datetime" />
>> >> type="xsd:date" sql:field="START_TIME" sql:datatype="datetime"/>
>> >> sql:field="CHANNEL_ID" sql:datatype="varchar(7)">
>>
>>
>>
>>
>>
>>
>> >> sql:field="SERIAL_NO" sql:datatype="varchar(12)">
>>
>>
>>
>>
>>
>>
>> >> type="xsd:double" sql:field="AMOUNT" sql:datatype="float" />
>> >> sql:field="MOPEX" sql:datatype="int" />
>> >> type="xsd:date" sql:field="SYSTEM_DATE" sql:datatype="datetime" />
>> >> type="xsd:date" sql:field="SYSTEM_TIME" sql:datatype="datetime" />
>>
>>
>>
>>
>> >> sql:datatype="varchar(10)">
>>
>>
>>
>>
>>
>>
>>
>> >> sql:datatype="varchar(10)">
>>
>>
>>
>>
>>
>>
>>
>> >> sql:datatype="varchar(10)" >
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> >> sql:field="Result" sql:datatype="int" />
>> >> type="xsd:byte" sql:field="QueryType" sql:datatype="int" />
>> >> sql:field="ErrorCode" sql:datatype="varchar(21)">
>>
>>
>>
>>
>>
>>
>> >> sql:datatype="varchar(122)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="POBox" sql:datatype="varchar(13)">
>>
>>
>>
>>
>>
>>
>> >> sql:datatype="varchar(30)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="Buildname" sql:datatype="varchar(21)" >
>>
>>
>>
>>
>>
>>
>> >> sql:field="Buildnum" sql:datatype="varchar(21)" >
>>
>>
>>
>>
>>