This project is read-only.


SFTP not removing remote files


I use SFTP Task from SSIS Extensions SQL 2012 64-bit

I am able to receive files (with Recievie files(s) option). Unfortunately when Remove Remote is set to True files on the remote server are not removed. Overwrite local works correctly and responds to setting True or False flag.
Closed May 14, 2014 at 8:16 PM by mcpunjabi


mcpunjabi wrote May 19, 2013 at 6:13 PM

Do you have permission to delete file on the SFTP?

wiaderny wrote May 20, 2013 at 8:49 AM

Yes. Using same credentials and various sftp clients I am able to delete the file.

kgiota22 wrote Jul 18, 2013 at 7:10 AM

Any feedback on this ? I am having the same issue. the remote files are not removed from the remote server.

Prashantpatil1003 wrote Jan 6, 2014 at 9:21 AM

Does anyone got solution to this problems?

wrote Jan 6, 2014 at 9:22 AM

wiaderny wrote Jan 7, 2014 at 9:35 AM

The only walkaround I know is to use WinSCP to delete/move files after downloading them with "ssisextension". Guess, it's not the solution You are looking for ;)

wrote Mar 28, 2014 at 3:18 PM

GrooveNeedle wrote Mar 28, 2014 at 5:16 PM

Any progress on this? I feel as if the removeSource property is being ignored by the task. I can manually delete the files through an FTP client with the same credentials, so permissions are not the concern.

Due to my client's constraints, it's important I can delete files on the SFTP site after I download them.

wrote Mar 28, 2014 at 6:35 PM

wrote Mar 29, 2014 at 3:50 PM

GrooveNeedle wrote Apr 10, 2014 at 5:39 PM

This is now working as of the April 1, 2014 release. Thank you!

wrote May 14, 2014 at 8:16 PM