designing a process flow like this in our CloverETL Designer (which is a visual tool for designing data transformations) is quite straight-forward and is only a matter of adding and linking 2 components and configuring the connections to both AWS and SQL Server. Furthermore, our CloverETL Server which is a runtime platform for automation and orchestration of such process flows will easily enable you to schedule the data loads to run on a regular basis or get triggered upon various kinds of events. More information about these tools can be found on our website
where you can also easily download a 45-day trial to see if Clover is what you are looking for. Just click on the DOWNLOAD 45-DAY TRIAL button, fill in a simple form and you are good to go with trying out Clover.
Once you start CloverETL Designer you will be welcomed with a tutorial which will guide you through the basics of how to use it and will provide you with many simple, yet useful examples in the section Help > CloverETL Examples. If you stumbled upon any issue during the trial feel free to reach out to us either here on the Forum or by shooting us an email to firstname.lastname@example.org