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.