File Watcher Task

File Watcher Task watches a folder waiting for files and when an available file is found the task completes
Download

File Watcher Task Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Freeware
  • Publisher Name:
  • Konesans Ltd
  • Operating Systems:
  • Windows All
  • File Size:
  • 580 KB

File Watcher Task Tags


File Watcher Task Description

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 detects 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 task can also be set to look for existing files first, before starting the monitoring phase. 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. Advanced warning of a file having been detected, but not yet available is returned through the OnFileWatcherEvent. This event does not always coincide with the completion of the task, as completion and the OnFileFoundEvent is delayed until the file is ready for use. This event indicates that a file has been detected, and that file will now be monitored until it becomes available. The task will only detect and report on the first file that is created or changes, any subsequent changes will be ignored. The component is provided as an MSI file, however to complete the installation, you will have to add the task to the Visual Studio toolbox manually. Right-click the toolbox, and select Choose Items.... Select the SSIS Control Flow Items tab, and then check the File Watcher Task from the list. Requirements: ■ SQL Server 2005 Integration Services


File Watcher Task Related Software