How to load data from Multiple tabs in excel using SSIS

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  June 27, 2012 at 12:04 am

  #147161

  Hi,

  I have an Excel sheet with 7 tabs. Each sheet contain different columns(Not same metadata).

  Need to load the data to 7 tables from this sheet.

  Can you please let me know how to do this in a single SSIS package?

  Regards

  SqlStud

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  June 27, 2012 at 1:35 pm

  #1506344

  7 different OLE DB Data Sources

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato