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 9:07 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
the package can start from the point it failed when its executed next time After the problem was corrected ,it 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 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 #1040389
Posted Wednesday, December 29, 2010 12:13 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 13,046, Visits: 10,815
Does the account that SQL Server Agent runs under has the necessary rights to access the folder where your checkpoint file is stored?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1040535
Posted Friday, December 31, 2010 7:11 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
how would i know if the agent has the acess to the folder path ?
Post #1041377
Posted Sunday, January 2, 2011 11:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 13,046, Visits: 10,815
First verify which service account SQL Server Agent uses (in SQL Server Configuration Manager)
Then go to the folder and make sure the appropriate rights are set.

For more information, see:

http://msdn.microsoft.com/en-us/library/ms191543(v=SQL.90).aspx




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1041645
Posted Monday, January 3, 2011 8:51 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
i actually have created a new credential and created a new proxy so that the sql agent can use that proxy ... but i cant understand how to use that proxy to point to the folder whare the check points will be saved ?
Post #1041879
Posted Tuesday, January 4, 2011 4:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 13,046, Visits: 10,815
When you create a job, you can specify the proxy in the jobstep.
For more information, see:

http://www.mssqltips.com/tip.asp?tip=1199




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1042301
Posted Thursday, January 6, 2011 7:55 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
works great thanks
regards
greg
Post #1043776
Posted Thursday, January 6, 2011 7:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 13,046, Visits: 10,815
koolme_85 (1/6/2011)
works great thanks
regards
greg


No problem. Glad that it worked out.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1043778
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse