Hi, I have implemented a WMI Event Watcher in my SSIS package which polls a directory at 5 second intervals for the presence of files. I have noticed that at times this file watcherservice doesn't seem to function. Yet if I stop and startthe package it usually works again. Everything is running locally, including the polled folder. Has anyoneexperienced similiar issues, or may know the cause/fix of this problem? Thanks.

Yep, I have the same problem. Did you solve it? Or does anyone else have any ideas? Mike

Haven't experienced it, but maybe this is a workaround: put the WMI task in a continuously loop and add a time out to the wmi task. This stops and restarts the WMI task every X seconds/minutes/hours. Example: http://microsoft-ssis.blogspot.com/2010/12/continuously-watching-files-with-wmi_25.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

How big are the files. I have seen it not pick up files because the downstream task kicks in before the file finishes writing. (Amongst other others) This can make it look as if the WMI has stopped, but it hasn't really. To be hoest, I tend to use the Konesans File Watcher instead. It's easier to use, more reliable, and has an EOF marker. http://www.konesans.com/products/file-watcher-task.aspxPeter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/