IO Kit for SSIS

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

Read a plaintext file into a variable.

FileContentsVariable

The name of the variable to copy the plaintext file into.

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.
The maximum file size that can be loaded into a package variable may depend on your hardware and operating system.