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("S QLXMLBulkLoad.S QLXMLBulkLoad.2 .0")
objBL.Connectio nString ="provider=SQLO LEDB.1;data
source=devpc1;d atabase=Winterg reen;integrated security=true;"
objBL.ErrorLogF ile = "c:\error.l og"
objBL.Execute "c:\customermap ping.xml", "c:\customers.x ml"
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]

Re: loading XML to SQL SERVER error

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]

Re: loading XML to SQL SERVER error

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]

Re: loading XML to SQL SERVER error

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