Delete File on FTp Site 1

[klewis10367]

Does any one have the general code using the ActiveX script task to delete a file from an FTP site?

 

[fuzzyocelot]

This is what we do to delete files from an FTP site:

First write a script file using ActiveX:

'**********************************************************************
'  Visual Basic ActiveX Script
'************************************************************************

Function Main()
	Dim oFSO,  oFile

'************************************************************************
' 	Delete file from FTP server.  
'************************************************************************
	set oFSO = CreateObject("Scripting.FileSystemObject")
	set oFile = oFSO.CreateTextFile("c:\ftp_remove_file.txt", true)
	oFile.writeline "lcd c:\"
	oFile.writeline "open xxx.xxx.x.xx"
	oFile.writeline "login_name"
	oFile.writeline "password"
	oFile.writeline "cd /download"
	oFile.writeline "del somefile.txt" 
	oFile.writeline "quit"
	oFile.Close
	set oFile = nothing
	set oFSO = nothing

	Main = DTSTaskExecResult_Success
End Function

Then use an Execute Process task to run the script:

Win32 process:  ftp.exe
Parameters:	-i -s:c:\ftp_remove_file.txt

I hope that helps!

 

[richrich05]

Thanks that was very helpfully for me too.

 

[fuzzyocelot]

You are welcome! Glad to hear it.