Read each excel sheet RRS feed

  • Question


    I have an excel spreadsheet with several sheets.
    These sheets get populated with data from an external source database i.e. a third party application.
    I would like to create a SSIS package to read the data in each sheet.
    Please note that I do know how to create SSIS package to read an excel file with only one sheet.
    Is there a functionality in SSIS to loop though each sheet in one excel file?
    Friday, November 2, 2007 2:38 PM