topic Re: Cannot delete records in MSSQL in Talend Studio

Cannot delete records in MSSQL

LGreenkic1624202166 — Sat, 16 Nov 2024 00:02:01 GMT

Hi all,

I try to delete some date-based records in some MSSQL tables and I am using a tdbinput -> tlog - > tdboutput flow to do this.

The flow runs as expected, but I can run it over and over again, because the records are not deleted at all.

Does anyone know what can cause this or why this is happening?

Prakhar1 — Mon, 21 Jun 2021 07:37:56 GMT

Did you selected the commit option in the tDBInput ?

or u a tCommit component in your job?

gjeremy1617088143 — Tue, 22 Jun 2021 06:47:48 GMT

Hi, as @prakhar dubey say it can be non commited transaction so check this first,

also maybe it can be foreign key issue, maybe you have to delete entries from a child table.

Send me Love and Kudos