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 |
|
vipinjha123
Starting Member
45 Posts |
 Posted - 2012-07-11 : 04:08:49
|
| subj-Multiple excel sources(different structure) load into single destination Dear All, I have around 100 process excel sheet in my report. Every Process have different structure.this is a daily basis excel sheet. 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. anybody knows the logic pls explain the processRegards,Vipin jha |
|
|
|
|
|
Multiple excel sources(different structure) load