SSIS Usage of Checkpoint File  Checkpoint usage with events I
found that saving checkpoints at event execution is bit
different too. And it is very important to be aware of it
because we often write codes in events. Once the package is
restarted using a checkpoint file, depending on the point of
failure, it fires some events but some are not. Let’s configure
one package for testing. Create a new package and add a Script
Task. Set the checkpoint configuration like below:      Property
Value    CheckpointFileName
 D:CheckpointFilesSamplePackageCheckpoint.xml    CheckpointUsage
 IfExists    SaveCheckpoints  True  Script Task    
 FailPackageOnFailure  True  Add code like below to the Script
Task. It just pops-up a message.  ‘ code 1 MsgBox(“Script task
executed!”) Dts.TaskResult = Dts.Results.Success  Configure the
events below in the Script Task. Add a Script Task to every
event and code for displaying proper message boxes about the
event.  Event    Event Script Task message  OnPreExecute
 ”OnPreExecute event f