Thursday, July 5, 2012

How to create Checkpoint in SSIS

Checkpoint
It can restart failed package from the point of failure, instead of rerunning the whole package. If a package is configured to use checkpoints, information about package execution is written to a checkpoint file(.csv). When the failed package re-run, the checkpoint file is used to restart the package from the point of failure. If the package runs successfully the checkpoint file deleted.

Enable Checkpoints


Then, set the all the task property FailPackageOnFailure is True.

Advantage

 Avoid repeating the downloading and uploading of large files.
 Avoid repeating the loading of large amounts of data
 Avoid repeating the aggregation of values.