Execl Sheets looping

• ss-710497

  Old Hand

  Points: 338

  More actions

  April 21, 2008 at 4:01 am

  #124880

  excel file is having more than one sheets of data with same strecture how to load that data into destination? can i use Foreach loop container?how? any one explain?

• afgone

  SSCommitted

  Points: 1551

  More actions

  April 21, 2008 at 4:10 am

  #804829

  try this:

  http://bi-polar23.blogspot.com/2007/09/loading-multiple-excel-files-with-ssis.html