I'm trying to determine which tool to use.
I have both Talend and SSIS to write data to SQL SERVER tables. It takes SSIS 3 seconds to write 100k records and it takes Talend 2 minutes. I have some tables with millions of rows, so this could be very time consuming if I went with Talend.
I'm using Talend's tMSSQLOutput to write the data to SQL Server. Is there a faster component to use e.g. bulk load data for SQL SERVER?.
Please check if you have enabled the batch mode in he advanced settings. The batch size should be the same as the commit size.
Another very fast approach is using the bulk output: tMSSqlOutputBulk
