I have a WMI Event Watcher Task for watching a directory on the local machine.
The query is
SELECT * FROM __instancecreationevent WITHIN 10 WHERE TargetInstance ISA 'Cim_DirectoryContainsFile' AND TargetInstance.GroupComponent='Win32_Directory.Name=\"C:\\\\\"'
We are using SQL Server 2008 on Windows 2008 R2 64-bit machine.
This package works fine when run from an account in the Administrators group.
If the account running the package is not in the administrator's group, the package fails with
Source: WMI Event Watch directory for drop file WMI Event Watcher Task
Description: Watching for the Wql query caused the following system exception: "Access denied". Check the query for errors or WMI connection for access rights/permissions.
We turned autditing on for the directory in question and it appears that the package hasn't event attempted to access the directory. I also tried giving d
View Complete Post