How to read Data from multiple tabs of excel Sheet using SSIS RRS feed

  • Question

  • I want to load data into SQL Table from excel file . I have multiple tabs in a excel sheet and i need to load multiple excel sheet at a single time. Metadata in all excel sheet is same.  Only difference in that first tabs contains the header row and other doesn't. It is because while exporting the data into excel and if number of rows exceed excel 2003 limit it shifts data into next tab. (I can't use excel 2007 or higher).

    Currently i am using SSIS 2005 with excel 2003. Can you please provide me some suggestions.

    Friday, January 4, 2013 7:54 PM


  • Excel Sheet Tabs (Sheet1, Sheet2)... While Exporting Data some data fits into single sheet and some goes on 2 sheets . So, need to handle that also.

    Then its probably easier to use a foreach loop construction...

    Please mark the post as answered if it answers your question | My SSIS Blog: | Twitter

    • Marked as answer by Eileen Zhao Friday, January 11, 2013 7:33 AM
    Friday, January 4, 2013 10:27 PM

All replies