Schedule MS SQL queries, export results to CSV and transfer the file by ftp (all automated)

For one of my clients I am looking for someone to help me achieve the following: 1. MS SQL queries, written by my clients data analyst, should be scheduled 2. The results of those queries should be exported to a CSV file 3. This CSV file should be transferred to a 3rd party by ftp It must all be automated and scheduled so that my client doesn't have to do anything manually. This automated job probably needs to run on a daily basis. Preferably this will all be achieved without any 3rd party applications. Please let me know if you are able to help me with this. Kind regards, Ronald