question

tomgough79 avatar image
tomgough79 asked

WMI Event Watcher task issue in SSIS 2008

I'm getting an intermittent problem with the WMI Event watcher task. I've set it up to watch for a file being modified and not set any timeout on it. If the file is modified within a few minutes of the package being started, it picks up the modification and reports success. If, however, the task has been watching for some time when the file is modified, nothing happens - the task appears to just keep watching. The WQL source is: select * from __InstanceModificationEvent within 10 where TargetInstance ISA "CIM_DataFile" and TargetInstance.Name = "Filename" I've tried also setting a timeout and asking it to watch again after the timeout has expired, but still no luck
ssiswmi
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
raadee avatar image
raadee answered
I use the custom made File Watcher Task, in my scenario I want the file to detect when file transfer has completed and then kick off next step. Have a look if it has usage for your scenario. The wmi event watcher is somewhat unstable when I've been talking to people that use it.[File Watcher Task Link][1] [1]: http://www.sqlis.com/post/file-watcher-task.aspx
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tell them you created it ;) I installed it in test env, scanned it for av and tried it out for a couple of weeks, did not encounter any issues. Been running it in prod for a month+ without issues. But dont take my word for it, if they allow it..
3 Likes 3 ·
Thanks, I'll have a look. May depend on whether I'm allowed to install it though!
0 Likes 0 ·
:) I'll get persuading!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.