https://community.qlik.com/t5/Talend-Studio/Talend-vs-SSIS/m-p/2317610#M88038 I'm trying to determine which tool to use. &nbsp; <BR />I have both Talend and SSIS to write data to SQL SERVER tables. &nbsp;It takes SSIS 3 seconds to write 100k records and it takes Talend 2 minutes. &nbsp;I have some tables with millions of rows, so this could be very time consuming if I went with Talend. <BR />I'm using Talend's tMSSQLOutput to write the data to SQL Server. &nbsp;Is there a faster component to use e.g. bulk load data for SQL SERVER?. Tue, 26 May 2015 20:41:37 GMT Anonymous 2015-05-26T20:41:37Z https://community.qlik.com/t5/Talend-Studio/Talend-vs-SSIS/m-p/2317610#M88038 I'm trying to determine which tool to use. &nbsp; <BR />I have both Talend and SSIS to write data to SQL SERVER tables. &nbsp;It takes SSIS 3 seconds to write 100k records and it takes Talend 2 minutes. &nbsp;I have some tables with millions of rows, so this could be very time consuming if I went with Talend. <BR />I'm using Talend's tMSSQLOutput to write the data to SQL Server. &nbsp;Is there a faster component to use e.g. bulk load data for SQL SERVER?. Tue, 26 May 2015 20:41:37 GMT https://community.qlik.com/t5/Talend-Studio/Talend-vs-SSIS/m-p/2317610#M88038 Anonymous 2015-05-26T20:41:37Z https://community.qlik.com/t5/Talend-Studio/Talend-vs-SSIS/m-p/2317611#M88039 Please check if you have enabled the batch mode in he advanced settings. The batch size should be the same as the commit size. <BR />Another very fast approach is using the bulk output: tMSSqlOutputBulk Wed, 27 May 2015 07:02:40 GMT https://community.qlik.com/t5/Talend-Studio/Talend-vs-SSIS/m-p/2317611#M88039 Anonymous 2015-05-27T07:02:40Z