How to: Configure a Package to Use Checkpoints

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 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.


      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


Using Checkpoints in Packages


Package How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance