SSIS Folder Monitoring?

[mlager]

Is SSIS capable of monitoring a folder for a file? I'd like to monitor a folder that will have an XML file put into place by another system, and as quickly as possible import and process this file. If this is possible, how flexible is this folder monitoring. For example, can SSIS reconize when the file is there, check properties about the file, rename it, move it, etc. Any advice is appreciated!

 

[MDXer]

SSIS is capable of doing this in a not so efficient manner. To get this functionality you would have to have either a SSIS package that is always running or a Agent job that fires the SSIS package(s) every n seconds or minutes. Another option would be to build a small C# service that monitored the folder and when the file landed would execute the package(s).

 

[mlager]

What is the downside to having the package run all the time, drain on resources?

 

[MDXer]

well you would be desining a package into an endless loop where you would never have a logical exit. Scheduling a job to fire every minute or so around the time the file is sopposed to be there would be the more correct way.

 

[mlager]

I've read about the WMI Event Watcher task, is this something that would require the package to run endlessly?

 

[MDXer]

Not sure about the WMI task but for any task in apackage to run the package must be running.