Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLXMLBulkLoad Error Expand / Collapse
Author
Message
Posted Wednesday, February 15, 2006 9:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 16, 2006 8:29 AM
Points: 1, Visits: 1

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

Post #258713
Posted Thursday, February 16, 2006 3:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 2:55 AM
Points: 80, Visits: 337

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

 

Post #258962
Posted Tuesday, October 2, 2007 4:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 8, 2008 5:34 PM
Points: 1, Visits: 6
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
Post #405929
Posted Monday, July 12, 2010 2:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:17 PM
Points: 5, Visits: 69
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")
Post #951008
Posted Thursday, August 26, 2010 7:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 1:25 PM
Points: 9, Visits: 457
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!
Post #976081
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse