We have an inbound integration setup between an external system and Marketing Cloud. We are receiving daily files on External FTP directory which are loaded in data extensions.
The problem is I am not able to find any option to delete those file automatically after they are read by the Import Activity. And all these files are getting piled up on the External FTP server.
Is there a way I can automate the deletion of those files?
Best Answer
We're looking at deletion as part of controlling sensitive data on the SFTP. Do you have access to a safehouse as a file transfer solution? If not, you may need to create one (thanks Eliot Harper for the writeup)
If so, you can add a step to the end of your import automation workflow to move to the Safehouse. Files within a safehouse have a 21 day retention policy applied to them.
TL;DR: Move the files to a safehouse where they'll be deleted after 21 days.
Details on safehouses: https://help.salesforce.com/articleView?id=mc_overview_file_locations.htm&type=5
Creating a Safehouse:
SFMC Safehouse Retention Policy