Hello Martin B
Thanks for using MS Q&A Portal for posting your query
For additional columns, we wont be able to change the datatype of the column in copy activity. By default it will be string only.
If you want to change the data type, we should only use Derived column in data flow.
Please let us know if that answers your question!
BR