Import XML in SSIS

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  May 7, 2008 at 3:25 am

  #185104

  Hi,

  Im using an XML Source in a Data Flow Task conected to many OLEDB destinations to read (and split) an XML file. The file was supplied without an XSD so I generated one.

  My problem is that not all of the XML elements are imported (or are even visible to import).

  The elements 2nd line from end are all missing. Any ideas?

  Hopefully the XML file is attached!!

  Thanks

  Allen

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  May 7, 2008 at 5:30 am

  #811678

  I think I found the reason and answer here

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=103751&SiteID=1

  Does anyone have any further info on IgnoreRoot = False?