1 Reply Latest reply: Nov 15, 2016 12:21 AM by Yevgeniy Bykov RSS

    Delete file from FTP after load

      Good day.
      We have an issue with load from remote FTP:
      our partners give us access to their ftp where they deploy daily XML files, with one condition: we should delete files after load.


      It`s easy to load from, like:


      LOAD     *

      FROM [ftp://login:password@host/file.xml] (XmlSimple, Table is [campaigns/campaign]);


      But I confused by second part of task.

      How can we remove files after loading? I will be very grateful for any ideas.