1 Reply Latest reply: May 16, 2012 11:26 AM by Jason_(A_Non) RSS

    Techinical issue loading an XML file in to database


      i am trying to load an XML file into Oracle database using SSIS 2005. the XML file is huge with 4000+ columns and also has many sub catogoreys. if i try to load the file using XSD it is taking lot of space to read the entire file upto 10GB even if the data row in the file is only one. I am only loading 60 columns out of the 4000+ columns. please provide me any alternatives that you can think of.

      thanks in advance.