SSIS WMI Event Watcher Result

  • Is there a way to access the result of the WMI Event Watcher Task?

    If I look at the logs, the WMI Event Watcher gets the name and the extension of the file that gets added to the directory, but how can I retrieve that information? If I add the Script task, I seemingly can't access the information from the Task that triggered it.

    The requirement is that we can get a variable number of files created in a directory containing some data that needs to be read, manipulated and exported. The file names (they will start with the "N", but that's about it) and extensions can all be different, but ulitmately they are all flat files formatted in the same manner. I don't have control over the file naming and extension conventions. So I'd like to have the WMI Event Watcher to monitor for creation of these files and pass the file names and extensions, as they get generated, to the following tasks.

    All posts and solutions that I found so far rely on the Script task to re-read the directory and process a file that matches the same mask that the WMI watcher was triggered with, but I'd like to make sure I process the exact same file.

    Thank you for your help,

    Sergey

Viewing 0 posts

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