Reading 500 columns in Excel sheet using SSIS RRS feed

  • Question

  • Hi,

    I have to transform 500 columns from an excel sheet to Sql Server. In Excel 2k3 , I can read a max of 256 columns only.

    If I use Excel 2k7, then SSIS 2k5 excel source does not support excel 2k7. If I use ole db source then again it can read a max of 256 columns.

    Could anyone please suggest me how can we read 500 columns in excel sheet (Around 10000 rows) efficiently using SSIS 2k5.   


    Wednesday, November 17, 2010 10:53 AM


All replies