SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQLXMLBulkLoad Error


SQLXMLBulkLoad Error

Author
Message
Lynn Marie Love-302500
Lynn Marie Love-302500
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 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


SQL-DBA
SQL-DBA
SSC Eights!
SSC Eights! (859 reputation)SSC Eights! (859 reputation)SSC Eights! (859 reputation)SSC Eights! (859 reputation)SSC Eights! (859 reputation)SSC Eights! (859 reputation)SSC Eights! (859 reputation)SSC Eights! (859 reputation)

Group: General Forum Members
Points: 859 Visits: 463

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


rico-504591
rico-504591
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 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
danadolittle
danadolittle
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 76
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")
paultormey
paultormey
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 651
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search