Upload Multiple FTP files to SQL Server

Highlighted
Occasional Visitor

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!

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