Mike (9/9/2009)
What can be the cause for the following scenario?SSIS package executed by a job fails with the following error
"The package is configured to always restart from a checkpoint, but checkpoint file is not specified"
But the CHECKPOINTUSAGE property of the package is set to "Never", the SAVECHECKPOINTS is set to "False", and no file is specified under CHECKPOINTFILENAME.
These settings are all made within SSIS Designer
The CommandLine tab for the JOB STEP Properties show the following entry
/CHECKPOINTING ON
Anyone an idea for the root of this problem?
Silly question I suppose, but should /CHECKPOINTING ON, be there if you are not using checkpoints
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]