Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » WMI EVENT WATCHER TASK STAYS YELLOW
Add to briefcase

WMI EVENT WATCHER TASK STAYS YELLOW Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
jyoti_bhatt
Posted Wednesday, February 24, 2010 4:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 19, 2010 2:32 AM
Points: 38, Visits: 98
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?
Post #871815
Raunak Jhawar
Posted Monday, September 06, 2010 5:31 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:25 PM
Points: 946, Visits: 1,739
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\""

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #981047
eclispe66
Posted Tuesday, October 23, 2012 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 08, 2013 12:36 PM
Points: 9, Visits: 24
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\""
Post #1376210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.