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:
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.