I found out that the destination folder has to be empty.. but I do stil have a question.
I have a zip that contains 5 CSV files which I want to process and subsequently delete from the hard-disk. what would be an advisable way without creating a physical table? As I understand you cannot create a temp table that only exists during the process-flow correct?
Hi Freddy
We had faced a kind of same situation, but instead of unzipping we wanted to zip the files. We came up with the solution to create process-flow in which a temporary directory (using a GUID to make it unique). is created. At the end of the process-flow the temporary directory is deleted.
I think the same is possible for you. In a process-flow you can create a temporary directory using a GUID and unzip the contents in that directory. After successful processing of a file, you can delete it and afterwards delete the temporary directory in a process-step.
Be aware that you have to specify absolute paths folder the folders. We already posted this on this on the community. Zip file / Delete folder connector requires full path to Source folder
Relative paths could make your life easier
André