Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Adding a custom column to a copy activity

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, pleas...
  • pmscorca's avatar
    pmscorca
    2 years ago

    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.