Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

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.

  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.
      ms141009.note(en-US,SQL.90).gifImportant:
      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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.