Validate Data

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  February 10, 2014 at 11:35 am

  #283537

  Hi,

  I want to validate data in a table against an XSD schema. What is the best method? .. TableData convert to XML and validate against xsd with T-SQL or better complete with C #?

  Thanks

  Nicole

  😉

• PB_BI

  SSCoach

  Points: 17463

  More actions

  February 11, 2014 at 7:21 am

  #1687888

  Convert to XML then use one of two methods.

  You can do it with an XML task in SSIS:

  http://microsoft-ssis.blogspot.co.uk/2012/08/validating-xml-file-against-xsd-with.html

  Or a script task in SSIS using C#:

  http://microsoft-ssis.blogspot.co.uk/2012/08/validating-xml-file-against-xsd-with_6.html

  I've done this in the past without too much trouble. 🙂

  ---

  I'm on LinkedIn