Using SQLXML Bulk Load on the Server - SQL Sever 2000, Windows 2003 Server
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?
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not sure dbbishop - have you got a dev server set up that you can test this on?
a quick google search turned up this - http://social.msdn.microsoft.com/Forums/en-US/sqlxml/thread/c81d2007-6083-4c1d-a8bb-36ee0c816cb4
they didn't really answer the guys question, but they didn't say it wasn't compatible either. I'd test it on a dev box first :)
a quick google search turned up this - http://social.msdn.microsoft.com/Forums/en-US/sqlxml/thread/c81d2007-6083-4c1d-a8bb-36ee0c816cb4
they didn't really answer the guys question, but they didn't say it wasn't compatible either. I'd test it on a dev box first :)
ASKER
Looks like it worked. Thanks.
ASKER