Share via

Configure Checkpoints for Restarting a Failed Package

  • Article

You configure Integration Services packages to restart from a point of failure, instead of rerunning the entire package, by setting the properties that apply to checkpoints.

To configure a package to restart

  1. In SQL Server Data Tools (SSDT), 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

      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.

See Also

Restart Packages by Using Checkpoints