How to read data from multiple sheets in excel file in SSIS

• anandhaksc

  SSChasing Mays

  Points: 601

  More actions

  June 13, 2013 at 7:31 am

  #276336

  Hi,

  I'm beginner of SSIS. Hereby i wish to know how to create a package which read the data from Multiple Sheets in excel file and send sql table..Can anyone help how to do this..thanks in advance.

  Regards,

  Anandhaksc

• Vikash Kumar Singh

  SSC Eights!

  Points: 974

  More actions

  June 13, 2013 at 11:53 pm

  #1623963

  This should help you to solve this. Let me know if you had any issue dealing with this.

  SSIS: How to load multiple excel files into multiple SQL tables?

  SSIS: How to loop through Multiple Excel sheets and load them into a SQL Table

  Vikash Kumar Singh || www.singhvikash.in