Checkpoints: The power of restartability

Data transfer packages may transfer millions of rows every night and if one or more tasks fail during execution this may cause the package to fail. If we re-run a failed package then it will start from the first executable object in control flow, and this will be a problem because maybe a Data Flow Task which transferred 10 million records last night re-executed and got a lot of resource again; that doesn't sound worthy.

SSIS packages can be restartable, they can store the status of execution and start execution from the previous status, these are all supported by checkpoints. One of the most understandable definitions for checkpoint can be found in video games; Checkpoint will save the status of the game, and if the player failed, then the game will restart from the last status which was stored by the checkpoint.

SSIS Checkpoint provides a way to re-run package from the failed executable. In this recipe, we will take a look at how to use checkpoint...