SQLTeam.com | Weblogs | Forums

SSIS - Watching Files


#1

Hi, I working on a solution that is supposed to watch for a certain file and once the file arrives, another package is triggered or started. Has anyone got any ideas/solutions to share.

What I have done so far.

  1. I have used the WMI event watcher to watch for a file
  2. This is however not calling the package I want it to call
  3. This first step is working ok but not the second bit.

#2

Create a windows service to implement the WMI event watch.
From the service code call the package to execute