|
kond.mohan
Posting Yak Master
India
136 Posts |
 Posted - 07/10/2012 : 01:21:36
|
Dear All,
I have around 100 process excel sheet in my report.
Every Process have diffrent structure.this is a daily basis excel shhet.
but empid,domain,project,date and process columns are common in every excel sheet.
Instead of creating 100 source table for every process I am looking to load only 5 columns from every sheet into single Destination Table using SSIS.
any body knows without creating 100 sources to load data into single destination using ssis
|
|
different excel source structures load into one de
