Check Points in SSIS

SSIS Provides a Check Point capability which allows a package to restart at the point of failure.When you implement Check Point, the package created check point file it tracks execution of the package. As each task completes, it write the state information into file includes current value of variable.If the package runs successfully it deletes the check point file. If it is fails, the file contains complete information about which task completed or which task failed. After solving the problem, again if runs the package the system will start the package at the point of failure. By default it will not be enable. The check point file has 3 Package level Properties. This Check pointy will be use full for long running packages.

Check Point Properties:

Check Point File Name: It specifies the name and location of the file name. We need to set the property. The name can be any windows valid file with any name extension.

Check Point Usage:  

It Determines, how the package use the  Check Point File when the package executes. It has Three different settings.

• Always
• If Exists
• Never

Always: In this case, the package will always use the Check Point file and it fails if the file does not exists.

If Exists: The Package will use the Check Point. If Exists, it restart the package at the point of failure. Otherwise execution begins at the first control level.

Never: The Package will not use Check points even if it is exists. That means package will never restart only execute from beginning

Save Check Points: it specifies whether the package should write the Check points to file.

In order to work with Check Points a  task failure has to configure the property FailPackageOnFailure of true for each task for restart the package at the point of failure.

Limitation: It required data only in Control Flow Level. Contents in a Check Points are stored  in XML File. It contains several properties like PackageID, Execution Result and Variable values etc.1