I am newbie to the SQL server and I am using vbs to bulk load into the PUB
database.

The following is the error message, I receive.
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'
Error on Line 13

The following is my vbs.
'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Option Explicit
Dim objBL

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

Function LoadFile()

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "provider=SQLOLEDB.1;data
source=ASICORPDEV;database=pubs;uid=routeone;pwd=a siroute1"
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
MsgBox("Complete")
End Function

I am not sure the error is in XML or XSD. I can post it in case required.