Monday, March 26, 2012

New SQLXMLBulkLoad user--having problems

I am trying, for the first time to load an xml file into SQL Server 2000, and to get me going I am trying to execute the msdn example:-

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp

I have configured all the needed set up and keep getting this error:-

Automation error(80040e21)

With no real error info in the error log

The Connection string details are all correct..I have checked that

The error occurs at line:-

objBL.Execute "SampleSchema.xml", "SampleXMLData.xml"

Have you got any ideas…?

Has anyone actually managed to run this example without errors?


Appreciate your help

Thanks

Raj

Hello,

Send me the schema and the data file and I will try a repro.

Regards,

Monica

No comments:

Post a Comment