question

balaa-uk avatar image
0 Votes"
balaa-uk asked balaa-uk commented

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

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?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered balaa-uk commented

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

78726-dynamic.png

Depending on the datasets, there are various parameters for the same


dynamic.png (45.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

How did I miss that. Thank you so much

0 Votes 0 ·