We recommend that you use Microsoft Windows Authentication and a UNC share rather than an FTP share because FTP passwords must be stored, and the password is sent from the Subscriber or the computer ...
Backup Assistant helps you to backup your files (like database backups or log files) to FTP Server. It works on any platform. ( Windows, Linux and Mac.) ...
3. Excel files must be store in various sql tables with various schema and columns. So I did it like this by ssis : It’s our ingredients for cooking : Sql Server 2012 or above. SSDT 2012 or above.