Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Did you selected the commit option in the tDBInput ?
or u a tCommit component in your job?
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