Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-07-10 : 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