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!
