Post reply

WMI Event Watcher in SSIS 2008

  • September 28, 2011 at 7:33 am

    #248479

    Hi All,

    Im using WMI Event Watcher to import the excel file from folder. Below is the WQL query im using to watch

    [Code]

    SELECT * FROM __InstanceCreationEvent WITHIN 7 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"E:\\\\MyActive Folder\\\\WMI_Rawdata\\\\SSIS example\\\\Excercise\\\\Watcher\""

    [/Code]

    But it is not working it is stuck up in WMI EventWatcher task

    Machine Details : Windows 7 , 64 Bit and SSIS 2008

    please can any body help me to fix this issue

    Thanks & Regards

    Deepak.A

  • September 28, 2011 at 7:52 am

    #1387782

    I haven't used the WMI Event Watcher task specifically, but are you saying it's stuck on the event even when you create a brand new file in the target directory (please note that this event does not trigger is a file is modified). The point of a watcher task is to 'hang' on the watching step until the event is triggered...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply