How do I pass a static value as source column in Copy activity

Question

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?

Answer 1

Hey @Balachandran Kannan ,
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