February 15, 2006 at 9:27 am
Good Morning~
I'm very new to XML and BulkLoad...I am currently trying to import a XML file using SQLXMLBulkload into SQL Server 2000 using a VBScript in DTS. I'm getting "ActiveX component can't create object SQLXMLBulkLoad.SQLXMLBulkLoad.3.0"
We have SQLXML SP3 installed. I can't find any help with this error. Is it caused by the schema file being incorrect or is there an issue with SQL Server? I just need a starting point to track this down...I guess.
Thanks, Lynn
February 16, 2006 at 3:45 am
The script should look something like this...when you parse it, you shouldn't get an error. Whether it runs correctly is a question of having your database, table and schema correctly set up.
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkload.3.0")
objBL.ConnectionString = "provider=SQLOLEDB;data source=NAMEOFYOURDBSERVER;database=NAMEOFYOURDB;integrated security=SSPI"
objBL.ErrorLogFile = "C:\FAQImport\error.log"
objBL.Execute "C:\FAQImport\FAQschema.xml", "C:\FAQImport\TestDoc.xml"
MsgBox "Completed file import!", vbOKOnly + vbInformation, Title
set objBL = Nothing
End Function
October 2, 2007 at 4:20 pm
Hi,
I've been fooling with this all day. It turns out you need to have sqlxmlbulkload 3.0 installed on your local machine as well as the SQL Server even though the DTS package is running on the server.
Dunno why, but now it works
July 12, 2010 at 2:00 pm
It has to do with changes made to security in Vista and Win 2008 -
documentation (this is post SQLXML installation):
1)Update User Account Setting. Control Panel > User Accounts > User Accounts > Change User Account Control Settings > Set to lowest setting ‘Never notify’. Reboot.
2)After reboot: Open command prompt (DOS). Type from C prompt: runas /env /user:adminaccountname “c:\program files\internet explorer\iexplore.exe” Enter. Type in account pwd when prompted.
3)IE session will open up under the Service Account. Go to Internet Options under Tools >Advanced tab > Click Reset button. Close IE Browser for change to take place.
4)Update script files. If machine is running SQLXML 3.0 then modify script to use: Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
If running SQLXML 4.0 then use Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.4.0")
If running both SQLXML 3.0 & SQLXML 4.0 then use: Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.4.0")
August 26, 2010 at 7:05 pm
Also beware that in SQL Server 2008 the SQLXML component is no longer supplied.
Refer to http://msdn.microsoft.com/en-us/library/ms171744.aspx for download instructions.
Wasted 2 days getting a very simple VBScript to run!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply