0

I want to implement a process in which, once the Report is exported to the SFTP /Reports folder, it will be imported to a Data Extension.

How can I move the file to another folder in order to be able to import it? Is there any feature that has to be enabled for that purpose?

1 Answer 1

4

You can create data extract activity using 'Enhanced FTP File Move and Copy' extract type, it will help you to move/copy the file from one folder to another. Then you can create import activity to import the same file into your data extension.

To enable this data extract type, you will need to create a ticket with salesforce marketing cloud support team.

Data Extract activity_1

Data Extract activity_2

4
  • 1
    As a note, I do not believe that using this will activate a File Triggered Automation when the file is moved. Apr 3, 2019 at 12:52
  • 1
    No, it will not trigger the automation, however we can use those 2 activities in schedule automation. Apr 3, 2019 at 13:26
  • 1
    Agreed. I just wanted to make sure it was noted. The solution is valid and I have +1'd accordingly. Apr 3, 2019 at 13:36
  • Thanks for your feedback, I already asked to support to enable this extract type. As I don't need to activate the File Triggered Automation this solution should be fine. I will do it in a scheduled way. @Gortonington
    – fromero
    Apr 3, 2019 at 14:06

You must log in to answer this question.

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