Importing XML to SQL database

[leangross]

I made a package in sql server which imports xml to sql server the vbscript is listed below.

dim objBL 
Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
objBL.ConnectionString = "provider=SQLOLEDB.1;data source=(local);database=mydatabase;uid=sa;pwd=secret"
objBL.ErrorLogFile = "c:\error.log"
objBL.Execute "d:\test.xml", "d:\test_xml.xml"
Set objBL = Nothing

When I ran the package, the this error showed up:
Error code:0
Error Source=Microsoft VBScript runtime error
Error Description: ActiveX component can't create object:
"SQLXMLBulkLoad.SQLXMLBulkLoad"

Error on Line 6



What do i need to fix this error? Do I need to install anyting like a patch for sql server 2000?

Thanks in advance

 

[JVZ]

If you did not install SQLXML 3.0 SP2, then you need to before this script will work.

Link to download SQLXML 3.0 SP2 -

http://www.microsoft.com/downloads/...28-7071-4979-8a67-3cffcb0c2524&displaylang=en

Hope this helps.