1

Can we delete file from SFTP Import folder after import activity?

I have an automation that picks up the file based on name. The file is uploaded frequently on SFTP import folder and I have noticed an issue.

When we upload a new file, old file is read by the automation / import activity because file name is in same format except date.

How to resolve this issue?

Improve this question
10
  • I saw some posts on this and I don't think it's possible to delete the file programmatically
    – Stan Alachniewicz
    Commented May 3, 2018 at 19:26
  • Is it normal for import activity to consume older file? Is there any way to solve that problem if we cannot delete the file from import folder? Any workaround? Right now my automation is looking for : file name contains....
    – kuml
    Commented May 3, 2018 at 19:37
  • 1
    @kuml In the advanced settings you can configure rules to not consume a file if it is older than a set time frame.
    – Travis Naughton
    Commented May 3, 2018 at 22:51
  • @TravisNaughton Advanced settings of what? automation studio? Import activity?
    – kuml
    Commented May 4, 2018 at 11:35
  • I checked import definition and these are the only options I see (there is no option to NOT consume a file if it is order than a set time): Advanced File Options Skip if last import occurred less than the following number of hours ago: 0 Fail import if file is older than the following number of hours: 0 System buffer (hours):
    – kuml
    Commented May 4, 2018 at 11:38

1 Answer 1

Reset to default
0

There is a custom Data Extract activity type available called "Delete File From ET FTP or Safehouse", and that will allow you delete a file from the FTP site. However, it will only allow you to delete files from Safehouse or the Import or Export folders; no other File Locations.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .