Hi Arthur (or anyone that can help), Well, it looks like I celebrated too soon. The Konesan FileWatcher is not consistant in picking up files. It will do it for some time and then just stop. In the debug mode it just sits in a yellow state and does not pick up files. I don't know what the reason could be. Therefore, now that I am in a bind more than ever with our schedule :-) I need to go an alternative route. What do you think about polling the folder every 5 mins or so. Is that difficult to implement. If I can poll then I can use the rest of my components (Foreach Loop etc) as is. Do you have any other suggestions? Do you know of any articles that could help me implement polling very quickly like in a couple of hours... Thanks once again :-) MikeMike Kiser

Hi Mike, That's what I was dreaded of... I shared my experience, I had exactly the same issue Mike. I chose to use a .Net based Windows Service to detect files (already said that). This approach turned out is posted by somebody (almost the same I did) here http://msbimentalist.wordpress.com/2012/04/27/trigger-ssis-package-when-files-available-in-a-folder-part2/Arthur My Blog

Hello! I have developed a WMI Event Watcher Task Editor watches for files in a folder and triggers a Foreach Loop Container. MOST of the time this works beautifully, HOWEVER, sometimes it doesnt' work at all and in debug mode just sits there like it is watching for a file. I use the same file over and over to drop into the folder. Does anyone know what there might be erratic behavior with this WMI File Watcher? It is killing me in the Test Environment when testers drop files and sometimes it works and other times it doesn't. Thanks! MikeMike Kiser

Thanks as always, Arthur! Yeah, it is making me look really badly here at work with an unstable FileWatcher and us testing a new system. I can't tell you how much I appreciate you sending me this link. I will look at it and implement it. I was going to ask if you had a download site for your code but it doesn't look like there is an enormous amount for me to do (probably this weekend :-) Thanks for following my post here!! Mike Mike Kiser

You are welcome Mike! I trust with your determination to success and deliver a quality solution you are very valuable. Wish you sincerely a good luck and please do not hesitate to come back to our forums.Arthur My Blog

The WMI Event File Watcher Task is set to handle the file event once only, you will need to run the package in a loop or the WMI task in a loopArthur My Blog

Hi Arthur! Sorry I guess I didn't give all the info. It is inside an Infinite Loop Counter. Sometimes it runs several files and then just doesn't run with a new file is dropped (Same file). Very strange. Any ideas? Thanks! MikeMike Kiser

Hi again Arthur, Here are the WMI Options: AfterEvent Return with Success ActionAtTimeout Log the time-out and fire the SSIS event AfterTimeout Return with failure NumberOf Events 1 Timeout 0 Mike Kiser

Timing I guess is the issue. If you drop several files what happens? 1st disable antivirus scanning of the input dir Then try other FileWatcher components as http://www.sqlis.com/post/file-watcher-task.aspx I recall ended up creating Windows Service in C# with a File Watcher in it instead that would log a new file arrival then a package would periodically check that log for new files and process each.Arthur My Blog

Arthur! Once again you are a life saver!! I tried the Konesans FileWatcher you pointed me to and it works EVERYTIME! I don't know what is doing on with the WMI File Watcher but this will get me back in good graces here :-) Thanks Again!! MikeMike Kiser

A big smile here Mike, you are welcome any time but make sure it does work indeed well, test it thoroughly. Cheers!Arthur My Blog

Very wise as I just found a "situation" where it doesn't work. It is EXTREMELY stable at just dropping a single file in the folder. HOWEVER, if the file is in the folder and I open the Excel file up to make one change and then do a SAVE and close the Excel file, the FileWatcher doesn't see it as a new file. I would have thought that it would detect it as a new file and process it. Any idea why not? Thanks! MikeMike Kiser

Because you just saved an existing one.Arthur My Blog

Yeah, that makes sense! Thanks again! MikeMike Kiser

Arthur, I am duplicating your application for a FileWatcher Service, however, I can not find the following: Add Microsoft.SqlServer.ManagedDTS reference and add a using statement for the Microsoft.SqlServer.Dts.Runtime namespace. I am using VS2010 and it is not listed in my choices of References. Any ideas? Thanks! MikeMike Kiser