How to transpose SQL server Row to a column change source file column names dynamically based on reference input etc

Need some suggestion on creating a dynamic mapper which updates the source column names from a file based on a input document to specified target columns

Any suggestions and solution ideas are most welcome