Hi, im currently grabing data from a mssql server and importing it to aurora, the problem is that the speed of the transfer is so slow its currently going 4.11 rows/s is there a way to increase that? im not doing any big jobs just a connexion from one db to another and a query that grabs all the data.
Are you sure you are inserting in batches? Also, do you have the Output component set to "Insert" mode not insert/update?
Can you try using tELTMSSQLinput->tELTMSSQLMap->tELTMSSQLOutput ? it should also help increase in performance reducing execution time?
What does your query look like? The rate of 4.11 rows/s is not normal. Posting your issue with screenshots will get more visibility and more help.