Hi Pratim Das, Partha C ,
Thankyou for using Microsoft Q&A platform.
I understand that you want to perform column mapping between excel sheet which is the source in your scenario to the SQL DB which is the sink using copy activity.
You can navigate to the mapping tab and define the column mapping by unchecking the 'auto-mapping' option and mapping the columns manually , assuming that the sink table is already created with the defined schema that you have mentioned above.
Reference resource: Schema Mapping in Copy activity of ADF pipeline
If you want to copy multiple files to multiple tables, then you can go for dynamic column mapping as well.
Here is more details on it: Dynamic Column mapping in Copy Activity in Azure Data Factory
Hope it helps. Kindly accept the answer by clicking on Accept answer
button. Thankyou