WMI Event Watcher Task - Integration Services

Learn Microsoft BI Forum Core Servers Integration Ser... WMI Event Watcher Task

6/24/2009 4:55 PM

	shairal
9 posts

WMI Event Watcher Task

Hi Cutley,

You have helped me so much with SSAS, with videos and your forums, I'm wondering if you might be able to assist with some SSIS. I am not a programmer or SQL expert ... so I'm having a really tough time with this.

I am using the WMI Event Watcher Task to watch for the arrival of a file.
I have the following entered into the WqlQuerySource field in the WMI Event Watcher task.
When I run it, the task turns yellow but does not find the file when it shows up (stays yellow until it times out).

SELECT * FROM __InstanceCreationEvent WITHIN 10
WHERE targetinstance isa "CIM_DirectoryContainsFile"
AND TargetInstance.GroupComponent = "WIN32_Directory.Name=\"c:\\\\Users\\\\myfile\\\\TestFolder\\\\text.txt\""

I know that there is a third-party File Watcher Task, but I don't understand how it works either and have found a bit more information on this task.
Any suggestions would be greatly appreciated!

Thanks for all your help!

6/27/2009 3:53 PM

	cutley
363 posts

Re: WMI Event Watcher Task

The watcher is monitoring a directory. Any file, regardless of name, will trigger it. In effect, you are looking in a directory named c:\Users\myfile\TestFolder\text.txt, and not for a file named text.txt in TestFolder. So change your query to this:

SELECT * FROM __InstanceCreationEvent WITHIN 10
WHERE targetinstance isa "CIM_DirectoryContainsFile"
AND TargetInstance.GroupComponent = "WIN32_Directory.Name=\"c:\\\\Users\\\\myfile\\\\TestFolder\""

and then you will have to do some other magic to get the name of the file that just landed.

11/30/2011 9:38 AM

	ShaggyDogg
2 posts

Re: WMI Event Watcher Task

Modified By ShaggyDogg on 11/30/2011 8:00:10 AM)

On a similar topic, can someone please shed some light on what's wrong with this WMI EWT query string?

SELECT * FROM __InstanceCreationEvent WITHIN 10
WHERE targetinstance isa 'CIM_DirectoryContainsFile'
AND TargetInstance.GroupComponent = "WIN32_Directory.Name=\"d:\\\\Dir1\\\\SubDir2\""

Running the package gives me "[WMI Event Watcher Task] Error: An error occurred with the following error message: "Input string was not in a correct format.". but this seems to match all the examples found online.

Thanks in advance!

11/30/2011 10:52 AM

	ShaggyDogg
2 posts

Never mind - solved.. with this.. [code="plain"]SELECT * FROM __InstanceCRe: WMI Event Watcher Task

Modified By ShaggyDogg on 11/30/2011 8:53:08 AM)

Never mind - solved.. with this..

SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"d:\\\\Dir1\\\\SubDir1\""

Cannot spot the difference myself, but maybe I had a carraige return in the original that it didn't like (?)

Page 1 of 1

Learn Microsoft BI Forum

Core Servers

Integration Ser...

WMI Event Watcher Task