I have a simple job that collects data from one database and inserts in a table in another database. The job has a start step, transformation and success step.
Ideally the job would start, finish the transformation, mark job as success and then complete.
The issue I am facing is that the when the transformation is completed, it respawns. For testing purposes I am limiting number of rows to 500, the select and insert to db steps happen successfully but then go in a loop.
Attaching screenshots of the job and logs.

Log file (insert_to_wh.ktr is the transformation that keeps repeating):
Can someone point out why the transformation keeps on restarting and why the job doesn't end after the Success step?
