What I need is to set up a single data dump process (ETL) from MySQL to an MS SQL Database, into an OLAP database which can then be queried for simple reports as needed . . . essentially an archive from MySQL to MS SQL for long-term storage and reporting.
Once the process is set up, someone else can run the package as needed.