I need to design an ADF pipeline to copy a CSV file created on a particular Blob Store folder path named "Current" to a SQL table. After successful copy, i'll have to move the file to an archive folder.
Things i've accomplished: I'm using a Copy Data Activity that copies the CSV file and loads into my SQL table. On success, another copy data activity will copy the CSV file from "Current" folder to "Archive", after this i have a Delete activity that deletes the file from Current Folder.
Issue: This is totally fine where there is only one file at a time. But i want redesign this to handle multiple files imports. I want make use of ForEach activity. Please help.