Upload Multiple FTP files to SQL Server

Occasional Visitor



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!

1 Reply
SSIS is good place to start as you can automate start to finish with it