IO Kit for SSIS

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

Convert a file to a Base64 string and store in a variable.


The name of the variable to hold the file content.


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:



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.