XMLBulkCopy Error in VBScript
-
Hi Friends, I am trying to do Bulkcopy of xml records to SQL Server 2008. I am using the below code. But I am getting error "
ActiveX component can't create object SQLXMLBulkLoad.SQLXMLBulkLoad"
This is my code:
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "server=Testdb;Database=CApp;UID=dbo;Password=dbo;LANGUAGE=us_english"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "c:\customermapping.xml", "c:\customers.xml"
Set objBL = NothingPlease help. Thanks and Regards, R. Sangeetha Priya.
-
Hi Friends, I am trying to do Bulkcopy of xml records to SQL Server 2008. I am using the below code. But I am getting error "
ActiveX component can't create object SQLXMLBulkLoad.SQLXMLBulkLoad"
This is my code:
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "server=Testdb;Database=CApp;UID=dbo;Password=dbo;LANGUAGE=us_english"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "c:\customermapping.xml", "c:\customers.xml"
Set objBL = NothingPlease help. Thanks and Regards, R. Sangeetha Priya.
From this article : XML Bulk Load Examples (SQLXML 4.0)[^] It would appear that you need to change
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
To
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.4.0")
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch