I have a Copy activity and source has couple of columns. I want to pass a static value as additional columnto be written to the sink (a sql table). Is there a way to do it?
I have a Copy activity and source has couple of columns. I want to pass a static value as additional columnto be written to the sink (a sql table). Is there a way to do it?
Hey @balaa-uk ,
Yes, it is possible to provide a static value.
You need to add additional parameter in the dataset properties in the copy activity

Depending on the datasets, there are various parameters for the same
5 people are following this question.