ADF Add Custom GUID to Sink

Question

I have a Script task where I generate a Custom GUID using SQL: SELECT NewID() AS AzureDataFactoryCustomGuid1

I'd like to using the output of this in my sink. I'm trying to create an additional column in the Copy Data task using dynamic content but I think my syntax is incorrect.

@activity('Generate Custom Guid for Logging').AzureDataFactoryCustomGuid1

Can someone advise on how I do this please?

Thanks

Answer 1

Use the below expression to get the output of the script activity value.

Script activity output:

Additional column in Copy activity:

Expression:

@activity('Script1').output.resultSets[0].rows[0].AzureDataFactoryCustomGuid1

Alternatively, You can generate the GUID id with function @guid() in the dynamic expression