Validate Xml Data Against Xml Schema. Now we can use the XMLISVALID function in SQL to test against the registered XML Schema. By using this tool you can check the validity of XML against XSD quite easily.
If the XML document being validated contains an embedded reference to an external XML Schema or XML DTD that schema will not be used for validation. This is how my XML file looks like. Download Free Liquid Studio Community Edition Now.
The validator checks for well formedness first meaning that your XML file must be parsable using a DOMSAX parser and only then does it validate your XML against the XML Schema.
As soon as you have a XSD and add it to ValidationReader you can read XML with this reader and reader would validate the XML while it reads it. I have an XML file to validate against XSD schema. For more information see. Turning on this option will force Excel to check each XML file against the schema during import and export.