How to use File Functions in SSIS


This article guides you through how to use file functions in SSIS.



  1. Drag and drop an SSIS component; in our case, we will use the REST API task.
  2. Open the field where you want to use the function; the format is the file path, then the function name.
  3. Now use the example you want in the field; here are some examples with variables and plain text:

Get file name from full path

Plain Text:




File size in bytes

Plain Text:





Following these steps, you can easily use functions for your file paths in SSIS. For further assistance or inquiries, contact our support team via chat on our website or through email at


Refer to our Format Specifiers / Placeholder Functions article for more detailed information.