Hi @arkiboys ,
You can use a copy activity with just an additional column. Source dataset can point to any dummy file with one column or dummy table.
In the mappings tab you can remove the dummy column and have the additional column written to sink.
Please write to us if you need more help on this.
Thanks.