I appended date and time(yymmddhhmm) to the csv file generated by the SSIS package through adding variables and expression in the connection string.
However, when I tried to send the file through SFTP task, the package failed to run and return message: 'Source: SFTP Task SFTP Task Description: The File "Flat File Connection Manager" doesn't contain file path(s).'
I set the local 'flat file connection manager' in my SFTP task. It worked well in the past but started to have issue recently.
Could anyone help out?
Thank you very much.