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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSIS Problem With Checkpoint Settings

Author  Topic 

MGouders
Starting Member

30 Posts

Posted - 2009-09-09 : 17:36:19
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?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-09-09 : 17:39:29
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132547
Go to Top of Page
   

- Advertisement -