Will anybody please provide me explaination with an example for using FTP task in SSIS. I need to load a flat file from FTP server and then using foreach file enumerator i need to dump that data in sql server table..... Thank you, Rohit

Check this link to see how FTP task can be used to recieve files from a ftp server and put it on some location. Once the file is pulled, you can use a foreach loop (in case of multiple files) and a data flow task within that.Nitesh Rai- Please mark the post as answered if it answers your question

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