What is a Checkpoint Restart?
-
Checkpoint information are saved in a file
-
Checkpoint allows a package to restart without returning tasks that already successfully completed
-
Any loop containers are started over from the beginning of the current loop
-
Data flow tasks and Control flow define restart points
Checkpoint restart in SSIS uses a checkpoint file to save execution state. The package can restart from the point of failure without re-executing completed tasks - both control flow and data flow tasks define these restart boundaries.
Checkpoints in SSIS work at the level of control flow tasks and data flow tasks acting as restart units — when a package fails, execution can resume at the task that failed rather than starting the whole package over, using those tasks as the defined restart points. Loop containers, by contrast, restart from the beginning of the current loop iteration rather than resuming mid-loop, which is why that option isn't the general definition of checkpoint restart.