Checkpoints in SSIS – Implementing restart-ability

Checkpoints and Data Integrity: When the SSIS package use Checkpoints file, it tries to acquire lock on that file. Now if another instance of the same package is running and access the same checkpoint file, then it fails since the checkpoint file is locked by already running SSIS package. This ensures that no two instance of the same package can run simultaneously. Hence there will not be any data integrity issues.

Implementing Checkpoints:
To implement checkpoints, we need to configure only four properties:

1. Checkpoint file name –  Specify the name of checkpoint
2. Checkpoint usage – Choose any 1 of three values: Never, Always and IfExists
3. Save checkpoints – Set this property to true to restart the package from point of failure
4. 
5. Set FailPackageOnFailure to true for every task\ container used in the package

Checkpoint usage properties:

1. Never – Do not use checkpoints
2. Always – Always use checkpoints, if the file does not exists package will fail
3. IfExists – Package use checkpoint file if exists otherwise it creates it