SSIS Tutorial Part 100-Delete Folder with Files from FTP Server by using Script Task in SSIS Package

FTP Task/Script TAsk in SSIS Video Scenario:

We often have the requirement in which we need to delete the Folder from FTP Server. FTP Task have the operation in which we can Delete the Remote Folder but if FTP Server Folder ( Remote Folder) has the files, FTP Task will fail with below error.
"Error: 0xC001602F at DeleteDirectoryWithFiles, Connection manager "FTPConnection": Deleting folder "/FolderName" ... 550 The directory is not empty. "

How can we delete the folder with Files on FTP Server?


Solution:

There could be multiple solutions for this requirement. We can use Script task and check if the files exists in Remote Folder or not. If file/s exists then we can use First FTP Task to Delete all the files and second FTP Task to Delete the Folder.

If no file exits then we have to direct our flow to second FTP Task that will delete the remote folder.

Link to the blog post for this video with scripts

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers

[luisbarreto]

With some changes, I could use this script to send a file ?

[ColonelKurtz]

I would think in this scenario, since we are deleting the folder, that we would also want to catch errors thrown when there is no folder.  Or is something built in to catch that?