dynamic mapping of columns
===

I have two table source, destination.
The destination table has fixed columns ID,Product_name,Product_description.

In the source table there is three columns ID,Product_name,Product_description.

I want to map the columns in the source table to the similar columns in the destination table using SSIS.

The issue is that the column name ID in the source table may change to ProductID,uniqueID in the future.

column name Product_name in the source table may change to Name,name_of_product in the future.


column name Product_description in the source table may change to describe,desc in the future.


I want to map the columns of the source table to the destination table even if the column name changes, without mapping the columns manually everytime.

in the sense without touching the package.

Please help me with this.

Regards,
Preethi
