loading XML to SQL SERVER error

[Patrick Olurotimi Ige]

I'm trying to load XML to SQL SERVER
But after executing the *.*vbs code below i get the error:-

ActiveX can't create object :- SQLXMLBUlkLoad.
Why?
Am i misssing something!

** And what are the best ways to do this..can anybody forward me samples
in .NET!!
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.2.0")
objBL.ConnectionString ="provider=SQLOLEDB.1;data
source=devpc1;database=Wintergreen;integrated security=true;"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "c:\customermapping.xml", "c:\customers.xml"
Set objBL = Nothing

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[chris yoker via DotNetMonster.com]

hiya,
could it be that you are using tables that have foreign keys?
I don't know the ins and outs, but I quickly looked up this article:

http://www.sqlxml.org/faqs.aspx?faq=77
Hopefully, it'll point you in the right direction.

yogi

--
Message posted via http://www.dotnetmonster.com

[Patrick Olurotimi Ige]

Chris thx for the reply..
I have corrected the error
And again i installed the latest S.pack 3 for SQLXML.
And its working fine...
Aprat from using SQLBUlkLoad do u have any sample u can send me to using
Updategrams?
Thx


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[chris yoker via DotNetMonster.com]

hi,
I have no experience in that area. I simply googled and found a page that
could have potentially answered your post.

yogi

--
Message posted via http://www.dotnetmonster.com