SSIS XML source with DTD as schema

• idofriedman

  SSC Rookie

  Points: 43

  More actions

  December 27, 2008 at 6:00 am

  #127751

  I have an XML file that uses a DTD schema.

  I am trying to load it to SQL 2005 with SSIS XML source task.

  As well as I know XML Source doesn't support DTD so I tried converting it to XSD.

  But the results are not very good especially on the attributes that the XML file has.

  Some guidance would really be appreciated.

  The DTD is below.

  Thanks in advance,

  Ido Friedman