Four Stars

tMsSqlOutputBulkExec and Tablock Option

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

 

  • ESB
1 REPLY
Moderator

Re: tMsSqlOutputBulkExec and Tablock Option

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.