SQL Server Performance

SSIS WMI EVENT WATCHER TASK

Discussion in 'ALL SQL SERVER QUESTIONS' started by Mike Kiser, Feb 27, 2012.

  1. Mike Kiser New Member

    Hello!
    I am using the WMI Event Watcher Task to monitor a folder for a new file and then using a Data Flow Component to import the data into a SQL SERVER database. Everything is working great and I am getting "SSIS package "Package.dtsx" finished; SUCCESS. HOWEVER, the WMI Event Watcher is supposed to continue monitoring the folder for the next file that is created. How is this done when the Package seems to only run one time when it is Executed from the Solution Explorer of the BIDS?? I have tried everything.

    Thanks!! I have worked on this for hours. I really appeciate your assistance with this!
    Mike

Share This Page