Configure Checkpoints for Restarting a Failed Package
Applies To: SQL Server 2016
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.
In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want to configure.
In Solution Explorer, double-click the package to open it.
Click the Control Flow tab.
Right-click anywhere in the background of the control flow design surface, and then click Properties.
Set the SaveCheckpoints property to True.
Type the name of the checkpoint file in the CheckpointFileName property.
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.
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.