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

File Watcher Task UI Screenshot