topic Re: Commit and rollback based on count of records processed in Talend Studio

Commit and rollback based on count of records processed

Anonymous — Wed, 22 Aug 2018 08:34:29 GMT

Hi Team,

I am new to Talend, Below is my requirement

1) open the connection

2) link the connection to a subjob

3) in subjob i have a source as excel and target as sql server

4) i want to commit the target for every 10 records processed from the excel. (note that i want to use same connection used in point 1)

5) if there is any error encountered i want to rollback the data

Please help me in this regard

Thanks

Raj

Re: Commit and rollback based on count of records processed

TRF — Wed, 22 Aug 2018 11:49:27 GMT

Define the "Commit every" value into the tMSSQLOutput settings.
Commited rows cannot be rollbacked (this is the rule because of ACID property of the SQL engine).

Re: Commit and rollback based on count of records processed

Anonymous — Wed, 22 Aug 2018 13:18:03 GMT

I have a small question, when i am using the option of "Use existing connection"

I am not getting option of "Commit for every". Is there any other way we can handle this.

Thanks

Raj

Re: Commit and rollback based on count of records processed

TRF — Wed, 22 Aug 2018 13:32:03 GMT

Did you check Advanced Settings too?
https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/1zj_Uz5uO~UTXHaCzVK4OQ

Re: Commit and rollback based on count of records processed

TRF — Thu, 23 Aug 2018 23:21:09 GMT

Did this help?
If so, thank's to mark your case as solved (Kudos also accepted).