IO Kit for SSIS

Components to simplify working with files in SSIS. Download now.

Returns whether a file exists.

PathType

The method of specifying the directory to search. Available options are Direct, Variable, and Connection.

When specifying the PathType property via expressions, the following enumerated values are used:

PathTypeValue
Direct0
Variable1
Connection2

PathValue

The PathValue depends upon the options selected for the PathType property

  • Direct - A string literal representation of the folder (e.g. C:\DataDir)
  • Variable - The name of the variable which holds the location of the directory to search. (e.g. User::ProcessDir)
  • Connection - The name of the connection manager which will specify the location of the directory.

ResultVariable

A boolean indicating whether the specified file exists.

  • True - The file exists.
  • False - The file cannot be found.
The File Exists? task may fail to find a file because it does not exist or because the privileges of the user executing the package are insufficient to see the file. The task does not differentiate between the two.