Creating buffer/ processing multiple files SSIS

110 views Asked by At

I have a watch folder task that monitors a folder. when a file is dropped it runs an execute package task. I have a for loop to make this run all the time. I'm having problems when 2 files are dropped before the execute package task is completed. There could even be 2 files coming in at once. I need to process both files.

Is there a way of doing this, maybe create a buffer to keep track of all files coming in the folder?

This is different from the other question suggested because the files are not already in the folder. They will get moved to the folder at random times, and multiple files can come in at once. What I understood from the other question suggested was that the files are already in the folder when the package is executed. that is not my case.

0

There are 0 answers