exporting excel data to SQL Server table

[ShilpaSharma]

Hi

I am getting source in excel file. These files have different fields, while they are mapping to single db table

Example
Fields of Source1.xs
Issue ID 
Issue Name 
Issue Descrition 

Fields of Source2.xls
Business ID 
Business Name 
Business Description 


Mapping Columns of DB table
ID 
Name 
Descrition 


Can we make a single configuration file, where all the mapping rule will be defined and a single DTF, where loading data from source to database can take place? (if yes, give some sample) Or individual DFT will be the suggested approach?

Appreciate your help on it
Thx in Advance
Shilpa

 

[gk53]

check out

http://micktechblog.blogspot.com/2011/06/ssis-excel-import-with-unknown-number.html

it is one of the ideas of how to do that