Multiple workSheets of Excel to a table

• vkoka

  SSC Enthusiast

  Points: 190

  More actions

  April 24, 2010 at 6:10 am

  #220803

  HI

  I have an Excel which contains 10 worksheets with different names but the schema is same across all the sheets(columns and the metadeta are same). i need to load all the worksheets from that excel to a table using SSIS 2008.

  Can any one help me out.

  Thanks In advance.

• snookala08

  Old Hand

  Points: 391

  More actions

  April 24, 2010 at 12:49 pm

  #1157315

  Check this link.. it should help you

  http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx

• vidya_pande

  SSCertifiable

  Points: 5275

  More actions

  April 24, 2010 at 12:49 pm

  #1157316

  yes u can do that..you can select the sheet name also while selecting source..