We are using the SQLXML bulk load object to load XML to a SQL Server 2000 database in a DTS package. The load occurs with no problems at all when a client executes the package, but when it is run on the server, I get the error: ActiveX component can't create object: 'SQLXMLBulkLoad.SQLXMLBulk
Can someone tell me what needs to be installed on the Windows 2003 server to allow the code to execute as a job on the server?
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.4.0")
objBL.ConnectionString = "provider=SQLOLEDB;data source=servername;database=user;integrated security=SSPI"
objBL.KeepIdentity = false
objBL.ErrorLogFile = "c:\error.xml"
objBL.Execute schemaFile, inputFile
set objBL = Nothing