One Star Orr
One Star

Talend vs SSIS

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?.
1 REPLY
Seventeen Stars

Re: Talend vs SSIS

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