Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MGouders
Starting Member
30 Posts |
 Posted - 2009-09-09 : 17:36:47
|
| 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 DesignerThe CommandLine tab for the JOB STEP Properties show the following entry /CHECKPOINTING ON Anyone an idea for the root of this problem? |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-10 : 06:29:50
|
quote:
The CommandLine tab for the JOB STEP Properties show the following entry /CHECKPOINTING ON
I'd suggest you set the CHECKPOINTING to OFF in the job step. It's under the Execution options tab. |
 |
|
|
MGouders
Starting Member
30 Posts |
Posted - 2009-09-10 : 10:46:53
|
| Hi YellowBug,Thank you for the hintSince I was not aware of the Execution options tab, I modified the command line entry under the Command Line tab manually.Looking today at the modified job under the Execution options tab the setting have been changed accordingly to the Command Line modification.MikeHow is the saying again: More than one way leads to Rome |
|
|
|
|
|
|
SSIS Problem With Checkpoint Settings