I am a newbie to SQL server. I am trying to using SQLXMLBulkLoad. All I am
trying is to insert a record into the PUB db.

The following is the error msg
Error Source: Microsoft Data Transformation Services(DTS) Package
Error Description : Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: ActiveX component can't create Object:
"SQLXMLBulkLoad.SQLXMLBulkLoad.3.0'
Error on Line 13


The following is the VBScript in DTS. I have an XML and XSD and I am using
and I am using ActiveX Script task in DTS.

' Visual Basic ActiveX Script
'************************************************************************

Function Main()
LoadFile()
Main = DTSTaskExecResult_Success
End Function


Function LoadFile()

' VBScript source code
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
objBL.ConnectionString = "provider=SQLOLEDB.1;data
source=ASICORPDEV;database=pubs;uid=routeone;pwd=asiroute1"
objBL.ErrorLogFile = "C:\temp\error.log"
objBL.Execute "C:\Documents and Settings\Jagadish Raghupathi\My
Documents\Visual Studio Projects\Upload\Test_Jobs.xsd", "C:\Documents and
Settings\Jagadish Raghupathi\My Documents\Visual Studio
Projects\Upload\Test_Jobs.xml"
Set objBL = Nothing

End Function



Any help is highly appreciated.

TIA

I know this is like asking if the printer is plugged in, but do you hav
SQLXML 3.0 sp3 installed? If not it is available at microsoft.com.
Installing this cured the problem for me. I'm mot sure why MS does no
install this by default.
M

--
syclone4
-----------------------------------------------------------------------
syclone43's Profile: http://www.dbtalk.net/m20
View this thread: http://www.dbtalk.net/t29899