I have a report generated on a schedule and being dropped into my /reports directory in the Enhanced FTP server. I would like to then take that csv file and send it to an external SFTP File Location already defined.
Current Attempt - Creating an automation step that uses the File Transfer Activity to send the file to the File Location using the 'Move a File From Safehouse' option. The issue is that I have no idea how to get the csv file from the reports directory to the Safehouse so that the automation step can pick it up.
Maybe I should be using a different automation activity, but so far the documentation isn't helping and I haven't been able to find where this has been addressed in a previous question.