I have the folliwing connection to SQL in .vbs
When I run this code I get this error:
ActiveX component can't create object :
'SQLXMLBulkLoad.SQLXMLBulkLoad'
Any idea why?

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "provider=SQLOLEDB.1;data
source=BSARDAK;database=MyDatabase"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "c:\customermapping.xml", "c:\customers.xml"
Set objBL = Nothing

"anonymous" <anonymous (AT) discussions (DOT) microsoft.com> wrote

If you have SQLXML 3.0 sp2 installed, then try:
CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.2.0")

--
Bryant

I have XML spy installed.
Still not working using your connection string.