How to: Configure Checkpoints for Restarting a Failed Package

You can configure Integration Services packages to restart from a point of failure, instead of rerunning the entire package, by setting the properties that enable checkpoints. For more information on using checkpoints, see Using Checkpoints in Packages.


Using checkpoints and transactions in the same package could cause unexpected results. For example, when a package fails and restarts from a checkpoint, the package might repeat a transaction that has already been successfully committed.

To configure a package to restart

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want to configure.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow tab.

  4. Right-click anywhere in the background of the control flow design surface, and then click Properties.

  5. Set the SaveCheckpoints property to True.

  6. Type the name of the checkpoint file in the CheckpointFileName property.

  7. Set the CheckpointUsage property to one of two values:

    • Select Always to always restart the package from the checkpoint.

      Important noteImportant

      An error occurs if the checkpoint file is not available.

    • Select IfExists to restart the package only if the checkpoint file is available.

  8. Configure the tasks and containers from which the package can restart.

    • Right-click a task or container and click Properties.

    • Set the FailPackageOnFailure property to True for each selected task and container.

Community Additions