Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 WMI event watcher : new file - pb after timeout

Author  Topic 

Mathias
Posting Yak Master

119 Posts

Posted - 2008-08-19 : 08:17:10
I have a SSI with one WMI event watcher. The event watcher is looking for any new file creation in the folder c:\temp with the following WQL query : select * from __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent="Win32_Directory.Name=\"C:\\\\temp\"", there is also a timeout of 11s with "ReturnWithFailure" as eventtimeout.

There is two script tasks after it : one on Failure, the second one on Success.

The Success task works well when a file is being posted

but the program doesn't move to the script linked to the constraint "Failure" after the eventtimeout (after 11s). Any idea?
   

- Advertisement -