Deleting File on FTP Server after DTS Pull 1

[bustercoder]

Hello,

I have a DTS Package which connects to an FTP server, pulls and process a file. I am having a challenge with deleting the file on the FTP server after I pull it. is this possible from the DTS package? Is it an FTP setting? I confirmed that I have permissions to delete files from the FTP server so any help would be appreciated.

Thanks,
Buster

 

[RiverGuy]

Write a batch file or VBScript file to delete your file and then call it with an execute process task.

 

[bustercoder]

Thanks for the advice. Could you please show me an example of such a script? I did some research and I now it involves something like:

CD /sourcedirectory
LCD /destinationdirectory
PROMPT
MGET *
MDELETE *

But I'm not quite sure how to put it together in an activex script or batch file. if you could show me an example that would be great.

Thanks,
Buster

 

[paskuda]

Read Priyank Gajera's post at the end of this thread. He wrote a script task to remove the files. The problem you have is well known issue with non-windows ftp servers and is not fixed yet.