hi, I have a master package which calls few other child packages using the execute package task. I'm enabling checkpoints on the master as well as child packages. The checkpoint file name is set dynamically using this expression: @[User::vcCheckpointFolderPath] +"\\Chkpts_"+ @[System:ackageName] +".xml" where @[User::vcCheckpointFolderPath] is the folder path initialized to the master package using xml config file (f:\checkpoints). The child packages receive their corresponding values for the folder pathfrom the master package using the parent variable config and use the same expression to derive their checkpoint filenames. Here's the strange thing that's happening. I'm running this package as an sql agent job. The master package begins execution andcreates it's checkpoint file. When it begins executing the child package it, the onError event of the master package is raised and this is the exception that I capture in the event handler. The file name is not valid. The file name is a device or contains invalid characters. The result of the expression "@[User::vcCheckpointFolderPath] +"\\Chkpts_"+ @[System:ackageName] +".xml""" on property "CheckpointFileName" cannot be written to the property. The expression was evaluated, but cannot be set on the property However the child packages still get executed without any errors. I can confirm that from thetrace I seton the event handlers on the child packages. Further while the child packages are executing I could see their checkpoint files being created. The checkpoint files are deleted when the child packages complete execution, proving the child packages executed succesfully. But because on the onError event in the master package there are two issue 1.Sql job is failing 2.The checkpoint of the master package does not record the execution of child packages as successfull. So when I restart the package it starts all over again from the child packages that were executed successfully. Any idea where the problem might be ?. I can set System:ropagate=False at the master package's onError handler, but not sure whether the checkpoint file will be able to record that the child packages executed successfully. Appreciate your inputs.

For the above scenario, I observed that when thecheckpoints inchild packages are disabledthe master package executed perefctly fine.

Getting similar type of error. But i don't want to disable checkpoint in child package. Is there a way???

Any suggestions??

It would be great , If someone from MVP or MSFT can answer this question.

Hi, all Any solution with the issue yet? I am having the simillar issue: I only set up checkpoint on the master package. During execution, child packages got executed, second child package failed, checkpoint file was created. Execution the package the second time, process was restarted from failure. All works as expected, but job history still shows following error at the beginning: The file name is not valid. The file name is a device or contains invalid characters. Description: The result of the expression "@[User::packageLocation] + @[System::PackageName] + "CheckPoint.xml"" on property "CheckpointFileName" cannot be written to the property. The expression was evaluated, but cannot be set on the property. I can see the expression being evaluated correctly when check at design time. By the way, What do you mean by "disable checkpoint in child packages"? Thanks Garry

Hi, all Any solution with the issue yet? I am having the simillar issue: i only set up checkpoint on the master package. During execution, child packages got executed and failed, checkpoint file was created, at last it still shows following error at the beginning: The file name is not valid. The file name is a device or contains invalid characters. Description: The result of the expression "@[User::packageLocation] + @[System::PackageName] + "CheckPoint.xml"" on property "CheckpointFileName" cannot be written to the property. The expression was evaluated, but cannot be set on the property. I can see the expression being evaluated correctly when check at design time. By the way, What do you mean by "disable checkpoint in child packages"? Thanks Garry