SQLServerCentral / Discuss Content Posted by Steve Moore / Article Discussions / Article Discussions by Author / SQLXMLBulkLoad Error / Latest Posts

RE: SQLXMLBulkLoad Error

paultormey — Thu, 26 Aug 2010 19:05:41 GMT

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!

RE: SQLXMLBulkLoad Error

danadolittle — Mon, 12 Jul 2010 14:00:21 GMT

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")

RE: SQLXMLBulkLoad Error

rico-504591 — Tue, 02 Oct 2007 16:20:21 GMT

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

RE: SQLXMLBulkLoad Error

SQL-DBA — Thu, 16 Feb 2006 03:45:00 GMT

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

SQLXMLBulkLoad Error

Lynn Marie Love-302500 — Wed, 15 Feb 2006 09:27:00 GMT

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