Configuration
FTP connection configuration
Host
adresa serveru ftp
Port number
port (default: 21)
Username
uzivatelske jmeno
Password
heslo
Encryption mode
mod pripojeni k serveru
Explicit (FTPS) Implicit (FTPS) None (FTP)
FTP reader configuration
Working Mode
Mode | Description |
---|---|
Read single file |
Reads always the same file specified in Path . |
Read all files |
Reads always all files (which fit the Mask filter) from the directory specified in Path . |
Read only new files |
Not recommended! Reads only new files from the directory specified in Path . |
Read only modified files |
Reads only newly modified files from the directory specified in Path . |
Warning: Try to avoid using
Reads only new files
mode. This mode keeps a list of read files and transfers it to the agent and back each time a step is run. The higher the number of files processed, the higher the traffic and CPU usage. The preferred way for reading only new files isRead only modified files
mode, which stores only the name and modification date of the last file read.
Path
Based on selected Working mode
:
Working mode | Description |
---|---|
Read single file |
Path to a file, e.g. C:\Directory\MyTextFile.txt . |
Other | Directory from which the files will be read, e.g. C:\Directory . |
Path
can also be taken directly from the input data by using a ${input.<input_column>}
placeholder, e.g. ${input.Path}
.
File mask
The search string to match against file names. This parameter can contain a combination of valid literal path and wildcard (*
and ?
) characters, but it doesn''t support regular expressions (e.g. *.txt
for text files, *.log
for log files, *.csv
for files with comma separated values etc.).
Mask
can also be taken directly from the input data by using a ${input.<input_column>}
placeholder, e.g. ${input.Mask}
.
Number of files to process
The maximum number of files loaded in a single task run.
Batch size | Description |
---|---|
0 |
Unlimited, all new files will be loaded. |
Greather than 0 |
Only specified number of files will be loaded at maximum. |
Input & Output Schema
Input
Data schema is optional
The connector does not expect a specific schema. The required data structure can be achieved by correct configuration. Although the selected connector doesn't require a schema generally, the individual integration task step may need to match the output data structure of the preceding task step and use a data schema selected from the repository or create a new input schema.
Output
FTP File (ver. 1.0.0)
Column | Data type | Allow null | Description |
---|---|---|---|
Name | string | No | nazev souboru |
Directory | string | No | adresar |
FullPath | string | No | cela cesta souboru vcetne adresare |
Extension | string | No | pripona |
Data | Base64 | No | obsah souboru |
Size | integer | Yes | velikost souboru |
Created | DateTime | Yes | datum vytvoreni |
Modified | DateTime | Yes | datum posledni modifikace |
Release notes
3.0.3
- Fixed shared nuget package versions.