Cannot seem to delete files from the SFTP in Automation Studio. It returns success but doesn't delete.
Step 0) Transfer file hello_world_2021-05-27T17-06-19Z.csv
to sftp import
folder.
Create Automation with the following:
Step 1) Create File Drop for files which start with hello_world_
Step 2) Import into DE
Step 3) Delete file from Import folder with Data Extract
Filenaming Pattern: %%BASEFILENAME_FROM_TRIGGER%%.csv
Extract Type: Delete File from ET FTP or Safehouse
FTP Folder: Import
Input Filename: %%BASEFILENAME_FROM_TRIGGER%%.csv
(to match naming pattern above)
Alternate Test:
Open SFTP via terminal.
cd Import
rm hello_world_2021-05-27T17-06-19Z.csv
Result:
Removing /import/hello_world_2021-05-27T17-06-19Z.csv
Couldn't delete file: No such file or directory
--
Any insight into why I can't delete files from the SFTP would be appreciated, thank you.
Edit: If i write a manual filename in and execute the activity once, it will delete. It's when i try to use substitute strings that it doesn't work. Can anyone else confirm that they have this working? Thanks.