Adding a custom column to a copy activity

[pmscorca]

Hi,

is it possible to add a custom column to a copy activity?

I'd like to add a load date for each tables copied from a source to a destination, using the for each activity.

Any helps to me, please? Thanks

[NandanHegde]

yes, you can use system variables and Functions to map to the additional columns .

So in your case UTCNow() and format it as per your needs

[NandanHegde]

Similar to ADF, in data pipeline copy activity as well you can add additional column 

https://stackoverflow.com/questions/68407493/adding-a-dynamic-column-in-copy-activity-of-azure-data-...

[pmscorca]

Hi, but how specifying the actual date in the highlighted box?

[pmscorca · Accepted solution]

Hi,

I've solved specified this column and the related expression:

@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')

In the lakehouse the actual datetime column is created as a string/char type and not a date type.