SFTP Destination

Dynamic Filenaming

Subscription output can be customized using dynamic date and time variables enclosed in @{}. This ensures consistency and automation in report generation. Placeholders like @{yyyy}, @{MM}, and @{dd} are automatically replaced with their corresponding date values when the report is generated. For a full list of supported date and time format options, refer to Microsoft’s documentation.

Here are some example filenames and what they would evaluate to if the subscriptions were executing on July 12th, 2025 at 07:25:00.

@{yyyy} Financial Report @{yyyyMMdd}.csv          -->  2025 Financial Report 20250125.csv

Report_@{yyyy}_@{MM}_@{dd}-@{HH}_@{mm}_@{ss}.csv  -->  Report_2025_07_12-07_25_00.csv

Or, more simply:
Report_@{yyyy_MM_dd-HH_mm_ss}.csv                 -->  Report_2025_07_12-07_25_00.csv

String literals can also be quoted to preserve them:
@{'Report_'yyyyMMdd'.csv'}                        -->  Report_20250712.csv

Another Dynamic Filenaming variable that is available is @timestamp (with no braces). Occurrences of this will be replaced as if it encountered @{yyyy_MM_dd_HHmmss}.

Back to SFTP Destination

Share your love