4

I am using the Automation Studio to initiate an Import of a file from an FTP server into a data extension in ExactTarget. I need to keep the file once it is done the Import, however it needs to be named something else on the FTP server so it is not reused. How would I go about doing this? There is a question similar to this on the stack exchange, however it was said to be incorrect by some of the comments. I tried using a File Transfer activity to re-upload the file, however this does not allow renaming (as far as I know).

Improve this question

3 Answers 3

Reset to default
3

You can use the move file functionality. Please see below

https://help.salesforce.com/articleView?id=000230276&type=1

Thanks

Improve this answer
1

As far as I know, you can't.

It may be worthwhile to ask SFMC Support if there are any special File Transfer business rules that can be enabled to do something like this.

Improve this answer
2
  • 1
    Okay, I'll look into that. Thank you. Do you have any other ideas for preventing file reuse? E.g. if the files that will be downloaded from the SFTP server on a scheduled basis were of the format Data_File%%Year%%%%Month%%%%Day%%, is there another way to make it so ExactTarget does not use the same date everytime, and always takes the latest one?
    – riv94
    Commented Jul 28, 2016 at 17:21
  • There are expiration settings on both File Imports and Transfers. Keep in mind they are based on UTC time, per the documentation
    – Adam Spriggs
    Commented Jul 28, 2016 at 17:24
0

Once you've imported the file into your target DE, couldn't you import the file to a temporary DE (overwrite), export it with a different name (using not only %%Year%%%%Month%%%%Day%% but also %%Hour%%%%Minute%%%%Second%% so it's going to be unique every time the automation runs), then transfer it to the FTP folder of your choice? I'm not sure of your exact requirements, but it seems like it could meet your needs.

If you're creating the initial import file via an extract activity, then it may solve your problem to simply add %%Hour%%%%Minute%%%%Second%% to your naming convention. I wasn't sure if you're doing that or importing it from an external FTP server.

Improve this answer
2
  • I am getting the initial import file from an FTP server. The problem is that I need to be able to not only export the file to a new location in the FTP, but also remove the original.
    – riv94
    Commented Jul 29, 2016 at 14:56
  • As far as I know, you can only remove files via FTP software or waiting 21 days for the file to be removed automatically.
    – Amy Polic
    Commented Aug 1, 2016 at 4:08

You must log in to answer this question.

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