How to validate XML file in SSIS

• AmolNaik

  SSCarpal Tunnel

  Points: 4767

  More actions

  January 7, 2010 at 3:57 pm

  #137190

  I have requirement to import XML file into SQL Server, before importing i need to validate the xml file against the given xsd (schema) file. How do i achieve this using SSIS?

  Thanks in advance!

  Best regards,

  Amol

  Amol Naik

• sabyasm

  SSCarpal Tunnel

  Points: 4324

  More actions

  January 7, 2010 at 6:25 pm

  #1100640

  [font="Comic Sans MS"]

  Does this help? http://goo.gl/PkyB

  [/font]

  [font="Comic Sans MS"]--
  Sabya[/font]