Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Implementing restartability checkpoints for packages Expand / Collapse
Author
Message
Posted Wednesday, December 29, 2010 8:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:22 AM
Points: 82, Visits: 192
Hi ,
i was working on Implementing restartability checkpoints for packages so that if the package failed
i would use the checkpoints and restart from the point of failure ,
now i have set the "savecheckpointproperty" to "true" (in the properties window in control flow)
in the "checkpointfilename" i provided a path and file name to a checkpointfile,
iv set the "checkpointusage" to "Ifexists" and iv set "failpackageonfailure" to true
now the job ran on SQL agent and job failed ,
it threw up the following error
"Failed during creation due to error 0x80070005 "access denied"
i think what it was trying to address was , it hade troubles creating the checkpoint file ,
or Something else
please give me some suggestions
thanks
Post #1040339
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse