15. Delete files after completion of data movement using copy activity of ADF

[@RohitSharma-ny1oq]

Great content plz keep continue, thanks for sharing knowledge 😊

[@sureshraina321]

Yet another great content , Thank you mam

[@AdityaSingh-uw9df]

I want to clear the sink folder before copying the data so that every time only the newly generated files are copied Can you please help me?

[@azurecontentannu6399]

Put a delete activity before copy activity

[@AdityaSingh-uw9df]

​@@azurecontentannu6399 Thanks 👍

[@leven4438]

Hi Annu - I have a requirement to copy activity to move files from blob to adlsg2. I want am using metadata - for each - copy activity. After copy I want to delete all the files from blob container folder. Could you please advise ?

[@azurecontentannu6399]

you can use 'delete' activity after your copy activity and point the dataset to the blob folder. Alternatively, in dataflow, in source option, there is a field called 'after completion' , there is an option called 'delete source files' which deletes the source file after loading data to destination. I would suggest the first option as it is more cost effective solution. Thankyou

[@leven4438]

@@azurecontentannu6399 I added delete activity inside for each and point to dataset folder (container/folder) but when I run the process it’s deleting folder as well. In dataset configuration- I provided the file path container / folder and left file name as blank