sâmbătă, 30 martie 2019

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

https://bit.ly/2GWSkNL Wftpserver secret sale page.
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 http://sqlage.blogspot.com/2015/05/how-to-delete-folder-with-files-from.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html

Niciun comentariu:

Trimiteți un comentariu