I have created SQL scripts using MSSQL Server 2019 that import and export data using text csv files. This was to prove the correct data was being used. I now have to automate this process. The client has set up an SFTP site and I have the necessary credentials. Is this something that SSIS will be able to do or will I need some other application? On the export side I will be executing a SQL script and need the results to be sent to a csv file which will then be forwarded to the SFTP server. On the import side I will be reading a csv file and inserting data into SQL.