0

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.

Improve this question
4
  • Use a foreach loop container in your ssis package. Commented Jun 18, 2015 at 18:53
  • possible duplicate of How can I loop through multiple files and process them using SSIS package? Commented Jun 18, 2015 at 18:54
  • I think it's different because I only process the files that are dropped in the folder. I can have 100 files in the folder, I only want to process the new ones being imported in. plus I can have CSV, XLS and TXT files so their not all the same. I will experiment with for each tomorrow, hopefully it works. Commented Jun 18, 2015 at 19:08
  • I ended up following the post suggested and modifying some areas to make it work in my case. I put the for each loop in an infinite for loop. and move the files from a monitoring to processing to done folder at the end of each stage. Commented Jun 22, 2015 at 12:13
Related questions
2
How can I loop through multiple files and process them using SSIS package?
0
How to create dynamic number of output files with SSIS?
0
SSIS process files from folder
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.