Dynamic Filenaming

Use date and time placeholders to generate subscription filenames automatically.

Subscription filenames can include date and time format tokens enclosed in @{} . At runtime, SFTP Destination replaces the tokens with the corresponding values.

Common examples include @{yyyy} , @{MM} , and @{dd} . Standard .NET date/time format patterns can be combined inside the braces.

Examples

For a subscription running July 12, 2025 at 07:25:00:

The following templates used in the file name setting produce these filenames:

Subscription File Name Generated filename
@{yyyy} Financial Report @{yyyyMMdd}.pdf 2025 Financial Report 20250712.pdf
Report_@{yyyy}_@{MM}_@{dd}-@{HH}_@{mm}_@{ss}.csv Report_2025_07_12-07_25_00.csv
Report_@{yyyy_MM_dd-HH_mm_ss}.csv Report_2025_07_12-07_25_00.csv
@{'Report_'yyyyMMdd'.txt'}1 Report_20250712.txt
[email protected]2 Report_2025_07_12_072500.xlsx
1 Use single quotes inside a template when you need to preserve a literal string.
2 @timestamp is shorthand for @{yyyy_MM_dd_HHmmss}.
Back to SFTP Destination Support Center