Thanks Steve.
Can the mapping of the columns (alias) be done dynamically via a script or Transformation?
Reason been is that I would be processing lots of different files with different formats.
E.g. abc.xls has 5 col going to SQL table (A), abc1.xls has 7 col going to SQL table (A), bbb.xls has 3 col going to SQL table (B) etc.
I can get the destination into a variable, can I get the alias column names into a variables?
Thanks again.