The Definitive Guide to Data Quality
It sounds like you simply want to read your file using tFileInputFullRow, unless I'm missing something.
and i want to modify the column names as per the requirement. append some text, change case. and some modifications.
Could you please elaborate your case with an example with input and expected output values?