Completion method

Specifies how the SFTP input device determines that file transmission is complete for an input file.

Values:

None
The input device uses no defined method to determine file completion. Transmission is complete as soon as the input device detects the input file.
Trigger
The input device determines that transmission is complete when it receives the trigger file for the input file. The Trigger patterns property controls how the input device recognizes a trigger file. A trigger file must have the same name as the input file, with a different extension.

If you select Trigger, the value of the Batching method property is not used.

Database name
SftpInput.FileCompletion

Usage note: An overrides file can also be used as a trigger file by specifying the extension of the trigger file as .*oth$. In this case, the file is first used as a trigger to indicate that the job has been received and then as an overrides file to update property values.