How to format Path / URL using date time format

Sometimes you need to set path or URL using date time format ( e.g. C:\Data\Myfile_2018_12_31_235900.csv ). You can use SSIS Expressions to do that but its not friendly solution. ZappySys Provides easy way to handle such issue. You can use Variable icon next to Path (  ) or Click on Edit Icon (  )

You will see Text editor with Variable Placeholder options.

You can use any valid Format Specifiers from this list 

Example:   c:\data\Payroll{{System::ContainerStartTime,yyyy-MM-dd HH:mm:ss}}.xlsx

Sample Output: c:\data\Payroll2018-01-04 13:43:05.xlsx

Preview text without placeholder

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/