File Watcher Task
The File Watcher Task does what it says really, it watches a
folder waiting for files. When an available file is found the task
completes, returning the name of the file for onward use within the
package.
The task will detect changes to existing files as well as new
files; both actions will cause the file to be found when available.
A file is available when the task can open it exclusively. This is
important for files that take a long time to be written, such as
large files, or those that are just written slowly or delivered via
a slow network link.
The full path of the found file is returned in one of the three
ways:
- The ExecValueVariable of the task.
- The OutputVariableName when specified.
- The FullPath variable of the OnFileFoundEvent.
The File Watcher Task is available free of charge from SQLIS.com, our
free community resource site for SQL Server Integration
Services.
Please note that our free resources are still subject to
copyright and usage is subject to acceptance and bound by the
accompanying license.
For more information and downloads, see File Watcher
Task on SQLIS.com