FTP(S) Reader

Version

3.0
Agent restriction

None
Processing type

Row by row
Multi-input step

Not Supported

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 is Read 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.