Click here to Skip to main content
16,020,811 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello All,
I am using SQLXMLBulkLoad to insert Data in multiple table in my Server. I have written following Code.
---------------------------------------------------------------------------------
VB
Dim objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
               objBL.ConnectionString = ConfigurationManager.ConnectionStrings("XMLConnectionName").ConnectionString '
               objBL.ErrorLogFile = "c:\error.log"
               objBL.KeepIdentity = False
               objBL.Execute("point2xsd.xsd","list.1.xml")
               objBL = Nothing

---------------------------------------------------------------------------------

When I am Executing the Code It doesn't give me an Error and It doesn't insert the Data in my Database. Here I thought some thing is wrong in my XSD or XML.

I have tried the Comparision and validation tool of
http://xsdvalidation.utilities-online.info/[^]

It gives me an error of
org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'ListingDataFeed'.



My XSD File is : http://www.repeatproperty.com/point2xsd.xsd[^]

and XML File is:http://www.repeatproperty.com/list.1.xml[^]
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900