none
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.   

    Raj 

    Wednesday, November 17, 2010 10:53 AM

Answers

All replies