Hi everyone,

Please how do I copy a folder from an FTP location using the FTP task in SSIS. Currently, I can only move the files in the folder one after the other but I want to copy the folder at once.

Please I need urgent assistance. 

Re

Hi,

Try below links,

http://microsoft-ssis.blogspot.in/2011/08/foreach-ftp-file-enumerator.html

http://www.huangzhong.ca/ssis-retrieve-ftp-files-list/

http://www.mssqltips.com/sqlservertip/2884/sql-server-integration-services-ssis-ftp-task-for-data-exchange/

http://www.rad.pasfu.com/index.php?/archives/28-Transfer-Multiple-Files-from-or-to-FTP-remote-path-to-local-path-SSIS.html

http://devtechie.com/post/2012/01/09/Download-files-from-FTP-using-SSIS.aspx

Thanks.

These steps works fine for me but it doesnt copy the subfolders as well.

Hi lilutchay,

To achieve your requirement, we can uses a Script Task to get a list of ftp files and uses a Foreach From Variable Enumerator to loop through those files. Please note that in the Script Task, you can use the .Net variable folderNames to create some recursive function to loop through all subfolders as well. For more details, please refer to the following blog:
http://microsoft-ssis.blogspot.com/2011/08/foreach-ftp-file-enumerator.html

Or if you don't like programming, use a custom FTP File Enumerator in the foreach loop:
http://microsoft-ssis.blogspot.com/2012/01/custom-ssis-component-foreach-ftp-file.html

Thanks,
Katherine Xiong