tMsSqlOutputBulkExec and Tablock Option

Anonymous — Sat, 16 Nov 2024 09:37:45 GMT

Hi,

I would like to us the tMsSqlBulkExec option to load data in an attempt to migrate away from SSIS jobs. We have done a lot of testing both inside and outside of Talend. We found that the bulk insert statment "With tablock" runs many times faster than without. Unfortunately Talend does not allow me to set this option via the GUI and I can't find away to manually add tablock prior to compiling the job.

How does one go about manually altering the source code prior to compile or how can I request that the powers that created this transform add a checkbox to include the "with TABLOCK" option

Thanks

Re: tMsSqlOutputBulkExec and Tablock Option

Anonymous — Wed, 21 Jun 2017 07:51:36 GMT

Hi,

Have you tried to set "Action" as "Bulk Insert" to see if it is Ok with you?

So far, there is no "Tablock" option on tMSSqlOutputBulkExec component.

Here is a related jira issue:

https://jira.talendforge.org/browse/TDI-28301

Best regards

Sabrina

topic Re: tMsSqlOutputBulkExec and Tablock Option in Talend Studio

tMsSqlOutputBulkExec and Tablock Option

Re: tMsSqlOutputBulkExec and Tablock Option