Vaildate XML

Jan 20, 2010 at 5:56 PM

Hello,

Can someone please provide me with preferably an example or a "How to" for validation of XML?. I have tried this via XML task with no such luck. Please let me know if there is a custom task that can do this for me.

I have searched everywhere and have not found a good example and need this ASAP for work.

I have an XSD to validate against and will eventually loop through a folder via a for loop to validate the xml files that exist in the folder but for the time being I am just trying to validate a single xml file via a file connection in order to simplify things.

Thanks in advanced,
Andrew

Coordinator
Jan 22, 2010 at 1:26 AM

Simon Sabin just put  up a blog post about this: http://sqlblogcasts.com/blogs/simons/archive/2010/01/20/XML-Validation-in-SQL-Server-Intergration-Services.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+SimonsSqlServerStuff+(SimonS+SQL+Server+Stuff)&utm_content=Google+Reader