I would say this is a task for SSIS.

Use it to download the files from the FTP server and then if it downloads any execute a for each loop to import it into SQL.