@Singh, Gurprateek Thanks for using Microsoft Q&A forum and posting your query.
Using copy data activity could be challenging and it may need dynamic mapping implementation and the solution will be cumbersome.
Since all the tables have same column name which you would like to exclude, then data flow makes more sense in this case.
In mapping data flow after your source, have a select transformation and in that you can write below condition to exclude a particular column.
In the Input columns section for Source column section have this condition name != "yourColumnNameThatHasToBeExcluded"
and in the Name as section have $$
that means select transformation will consider or select all columns and values expect the only column that was mentioned in this condition. Below is an example:
When you do a data preview of your select transformation, you will see all columns except the one mentioned in the condition.
Hope this helps.
Please don’t forget to Accept Answer
and Yes
for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.