How to track the copy activity using job control file or 0 kb files(fin) in ADF?

222 Views Asked by At

As i am new to ADF,need help on below scenario.I need to copy the files azure blob to SFTP.The files are as below:

XYZ0034_20210320.csv XYZ0034_20210321.csv XYZ0034_20210322.csv

On coping these files to SFTP,to track the copy, need to create fin file or need to job control file/table at end of the copying activity.

for example: XYZ0034_202103200030.csv XYZ0034_202103200045.csv XYZ0034_202103200100.csv

Requirement:

XYZ0034_202103200030.csv XYZ0034_202103200030.fin

JOB Control:

XYZ0034_202103200030.csv Y XYZ0034_202103200045.csv Y XYZ0034_202103200100.csv N after copying to Y

1

There are 1 best solutions below

0
Raunak Jhawar On

This seems more diable using Azure automation runbook. You can use webhook activity in ADF to call this notebook which will do the following -

  1. Use a web hook to invoke this notebook
  2. The runbook creates a file on this SFTP