You aren't actually doing a copy at that point, what is your log destination? If a database, the Stored Procedure can log your details, if a flat file, then I'm guessing something like an Azure Function is required
Passing details of a copy data activity into another activity as its source

Bakar, Cem
276
Reputation points
I would like to pass the details of the copy activity into another copy activity after it is completed.
Let's say the first copy activity (Copy 1) moves 1000 records from A to B.
After copy 1
is completed, the second copy activity (Log Details of Copy 1) kicks in - without a designated source - taking the details of Copy 1
and saving it into another destination.
Accepted answer
In that case, a stored procedure is definitely the way to go
All is well now. Thank you very much.