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
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 10:39 AM
Points: 71, Visits: 170
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