question

cmrbkr avatar image
0 Votes"
cmrbkr asked cmrbkr commented

Passing details of a copy data activity into another activity as its source

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.

113924-screen-shot-2021-07-12-at-40405-pm.png


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

RyanAbbey-0701 avatar image
0 Votes"
RyanAbbey-0701 answered cmrbkr commented

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

· 3
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.

Sorry I should have been more clear with that.. The destination is database.
I'll check details of Store Procedure activity.

0 Votes 0 ·

In that case, a stored procedure is definitely the way to go

0 Votes 0 ·

All is well now. Thank you very much.

1 Vote 1 ·