Upload Multiple FTP files to SQL Server

Hello,

I want to be able to efficiently upload and update files from an FTP site to SQL Server.  I also want to incorporate records that have been scraped to update SQL with latest scraped details... I'm thinking SSIS is a good starting point to handle these processes - looking for ideas to chase.  I want to create an architectural picture of what this should look like and need some help.

Thank you in advance for your input!