Cannot delete records in MSSQL

[LGreenkic1624202166]

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]

Did you selected the commit option in the tDBInput ?

or u a tCommit component in your job?

[gjeremy1617088143]

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