Import from File
Category: Files
Version: 1.0
Last updated: June 15, 2026
Author: Any2Info
Description
The Import From File node allows you to import files from a configured file system into your data flow.
This node can retrieve one or multiple files from a file system location and make them available for further processing within the data flow.
The configured path can reference either a single file or a directory:
When a file is specified, that file is imported.
When a directory is specified, all matching files are imported based on the configured search pattern.
The process works as follows:
Select a valid Connection.
Configure the Path to a file or directory.
Optionally enable Subdirectories to include files from nested folders.
Define a Search Pattern to filter the files that should be imported.
Execute the node.
The matching files are returned to the data flow.
Configuration Options
Connection
Select the file system connection that should be used to access the files.
The selected connection determines where the node will search for files and folders.
This field is required.
Path
Specifies the file or folder location that should be imported.
This field is required.
The path may contain:
A fixed path value
A column mapping from a previous node
Examples:
C:\Import\customers.csvC:\Import\\Server\Shared\Invoices
When a column mapping is used, the node must be executed using the For Each Row execution type.
Subdirectories
When enabled, the node searches all subdirectories below the configured path.
When disabled, only files located directly in the specified path are processed.
Search Pattern
Defines which files should be included during the import.
The search pattern supports wildcard filtering.
Examples:
*.*
All files
*.csv
All CSV files
*.xml
All XML files
invoice_*.pdf
Files starting with "invoice_"
Only files matching the specified pattern are returned.
Output
The node returns one record for each imported file.
The output contains the following fields:
FileName
Name of the file
FileExtension
File extension
FileSize
File size in bytes
FileLastAccessTime
Last access timestamp
FileCreationTime
File creation timestamp
FileContent
File content
The output can be used by subsequent nodes for further processing.
Tips & Best Practices
Use specific search patterns to limit the number of imported files.
Enable Subdirectories only when files may be stored in nested folders.
Verify that the configured path exists and is accessible.
Ensure the configured connection has sufficient permissions to access the specified location.
Changelog
Version
Date
Change
1.0
June 15, 2026
Initial documentation version added.
Last updated
Was this helpful?