In my SQL SSIS package, I have exported some data to file.
I want to export to a file with following filename format: filename_YYYYMMDD_hhmmss.txt
In my expression builder, it type in the following:
"C:\\BlueCreek Files\\Account\\AmesAccount"+"_"+(DT_STR, 50, 1252) Getdate()+".txt"
C:\BlueCreek Files\Account\AmesAccount_2018-01-23 13:03:21.122000000.txt
This is close, but how can I get it in the exact format I want?