Hi All,

           Could you please let me know if there is any code to
loop through all the folders on the FTP site to find out if there
any files and transfer the files to the file server.
I want this to be done using Sqlserver DTS.
May be an activex script could help me out

R.suresh

You can take a look at this site:
http://www.sqldts.com/default.aspx?302

but do not only look at this individual article there are others that will help in the looping and finding specific file and folders.