WMI EVENT WATCHER TASK STAYS YELLOW

• jyoti_bhatt

  SSCommitted

  Points: 1950

  More actions

  February 24, 2010 at 4:01 am

  #138301

  Hi,

  I have a WMI Event Watcher task with the below WQL Query. Then task stays yellow even when a file named test.txt is dropped in C:\ drive?

  SELECT * FROM __InstanceCreationEvent WITHIN 60 WHERE TargetInstance ISA 'CIM_DataFile' AND TargetInstance.Name = 'c:\\test.txt'

  Can someone help me with how to process the ssis package after a file has been dropped in the folder?

  Many Thanks for your help?

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  September 6, 2010 at 5:31 am

  #1216875

  jyoti_bhatt (2/24/2010)

  ---

  Hi,

  I have a WMI Event Watcher task with the below WQL Query. Then task stays yellow even when a file named test.txt is dropped in C:\ drive?

  SELECT * FROM __InstanceCreationEvent WITHIN 60 WHERE TargetInstance ISA 'CIM_DataFile' AND TargetInstance.Name = 'c:\\test.txt'

  Can someone help me with how to process the ssis package after a file has been dropped in the folder?

  Many Thanks for your help?

  Jyoti,

  Chk dis out...

  SELECT * FROM __InstanceCreationEvent WITHIN 1 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" AND TargetInstance.GroupComponent = "Win32_Directory.Name=\"D:\\\\Package\""

  Raunak J

• eclispe66

  Old Hand

  Points: 323

  More actions

  October 23, 2012 at 12:55 pm

  #1552045

  Hi I have tried both options with the same result. The WMI Event Watcher Task remains in the yellow status.

  SELECT * FROM __InstanceCreationEvent WITHIN 5 WHERE TargetInstance ISA 'CIM_DataFile' AND TargetInstance.Drive = 'H:' AND TargetInstance.Path = '\\\\ExcelDrop\\\\' AND TargetInstance.FileName LIKE 'Test%' AND TargetInstance.Extension = 'xls'

  SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE

  TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"h:\\\\ExcelDrop\""