I am trying to run a SSIS package with checkpoint enabled. I have set a checkpoint file and the checkpoint usage property is ifExsists and Save checkpoint to true. If the package fails while running the checkpoint file is created but on the second run the package fails with the following error. Error: The package failed during execution because the checkpoint file cannot be loaded. Further execution of the package requires a checkpoint file. This error usually occurs when the CheckpointUsage property is set to ALWAYS, which specifies that the package always restarts. Error: Error loading value "<DTS:VariableValue xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>" from node "DTS:VariableValue". Please assist

Hi do you mark any of your tasks as a checkpoint (FailPackageOnFailure = true) ? Do you check that the package credentials got the read/write permissions on the file ?

I potential cause could be the ForEach Loop in your package, do you have any?Arthur My Blog

Sorry for the late reply. My packge has a ForLoop, but the strange thing happening is the checkpoint is not working for any of the task.For an execute SQL task too it fails to restart the package and throws the error Error: Error loading value "<DTS:VariableValue xmlns:DTS="www.microsoft.com/SqlServer/Dts"/>" from node "DTS:VariableValue". Error: The package failed during execution because the checkpoint file cannot be loaded. Further execution of the package requires a checkpoint file. This error usually occurs when the CheckpointUsage property is set to ALWAYS, which specifies that the package always restarts.

Is the checkpoint file residing in a UNC (remote) path? It seems the package has no rights to access it.Arthur My Blog

Thanks for the reply..but for some reasons the package is executing successfully now.With no modifications made from my end. Thanks for all the suggestions.