How to achive dynamic source destination header mapping in SSIS

See more:

SSIS

Can any one help me on below implementation…
-----------------------------------------------------------------------------------------------
Source txt File may come in below format
---------------------------------

Case-1
-------------
CName | Pan | Mobile
A | PANA1 | 1234567891
B | PANB2 | 1234567892

Case-2
------------
Pan_No | Mobile_No | CustomerName | Gender
PANA1 | 1234567891 | A | M
PANB2 | 1234567892 | B | F

Case-3
------------
Email | Mobile_Number | Customer_Name | PanNumber
A@gmail.com | 1234567891 | A | PANA1
B@gmail.com | 1234567892 | B | PANB2


Destination Table
------------------------------------------
Customer Table
----------------
C_Name | C_PanNo | C_MobileNo
A | PANA1 | 1234567891
B | PANB2 | 1234567892

ExternalHeaderMapping Table
-----------------------------------------
Id DestinationColumnName ExternalHeaderName
1 C_Name CName
2 C_Name CustomerName
3 C_Name Customer_Name
3 C_PanNo Pan
4 C_PanNo Pan_No
5 C_PanNo PanNumber
6 C_MobileNo Mobile
7 C_MobileNo Mobile_No
8 C_MobileNo Mobile_Number


In the above case I need to build the SSIS packge it should work for all the above three case even
the order of column is changed and new column being added.
In case-2 & Case-3 it should ignore the Gender and Email column.

I am new to SSIS, please help me how to achive the same with SSIS..I know it can only achive through Script component but
don't know how to do....