Hi Champs
I want to implement a rutine that watches for specific files in a specified folder.
I've found the WMI sample "File Watcher Task" for SSIS and it looks fine.
My question is now: how shall I run this package; shall I start it at let it run forever
And also how do I monitor that the package is running
Many thanks
Rogvi
The never ending DTSX package
Vince206
sellison14
That's entirely up to you. if you need it to run forever, then do so. You can put it in a for Loop so that it keeps on checking after it has loaded a file. If you only want it to run between certain times of the day then this is fairly easy to configure inside the For Loop.
Reply here with any problems.
You need to monitor the logs. If it is still logging then it is still executing. Perhaps it might be an idea to log to the Windows event log.
Another idea - you could build the package so that the last thing it does is send you an email to tell you the package has completed. If you don't receive the email then you know the package is either executing or failed prior to sending the email.
-Jamie