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.