Advanced ETL Processor can delete files from an FTP server with the FTP Delete Files Action. Use it when a package must clean up processed, temporary, or obsolete remote files after download, import, validation, or archiving steps have finished.
What You Will Learn
- Configure an FTP Delete Files Action in a package.
- Select the FTP connection and remote directory.
- Use variables when the delete target changes by workflow run.
- Check the execution log after deleting remote files.
Before You Start
Use a test FTP folder first. Delete actions are not the place to discover that a mask, folder, or connection points at the wrong remote files.
FTP Delete Files Action Docs
The FTP Delete Files Action documentation explains how Advanced ETL Processor removes files from a remote FTP server as part of a package workflow.
Start with the parameters tab, then check the connection parameter and remote directory selection. The FTP browser is useful for confirming the folder before you let the package delete anything.
Use the variables tab when the file path or mask changes between runs. During testing, review the execution log tab; it is much better to find a bad delete pattern in the log than in a phone call from someone missing files.
Related package actions include FTP Download, FTP Upload, FTP Files List, FTP Move Files, FTP Rename File, and FTP connections.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.