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

SSIS - CheckPointFile Expand / Collapse
Author
Message
Posted Friday, August 03, 2012 3:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 7:44 AM
Points: 168, Visits: 73
I am using CheckPointFile and the following properties i have set in my package.

CheckPointFileName: checkpointlog_oms.chk
CheckPointUsage: IfExists
SaveCheckpoints: True

I am able to run it manually through Package Utility and Visual Studio.

I have imported into msdb(Stored Packages\MSDB) and created SQL Server Agent Job.

When i am running it through Agent Job, getting the following error

ERROR:
Executed as user: STAGING\stg66sqlagentukstrep. Microsoft (R)
SQL Server Execute Package Utility Version 10.50.2500.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.

Started: 08:34:17
Error: 2012-08-03 08:34:23.24
Code: 0xC001604D
Source: IGHS_BI_OmsArchive
Description:
Checkpoint file "CheckPointLogIGHS_BI_OmsArchive.chk" failed during creation due to error 0x80070005 "Access is denied.". End Error Could not execute package because of error 0x80070005. Started: 08:34:17 Finished: 08:34:23 Elapsed: 5.382 seconds. The package execution failed. The step failed.

Can any one please help me out in this if you have encountered the same problem?
Post #1339706
Posted Tuesday, August 07, 2012 2:14 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 07, 2014 2:09 PM
Points: 79, Visits: 242
The error indicates that the SQL Server account which you have setup to run integration services does not have permission to create file or say create any file on the drive. Check the user id and see does it has access to create files to drive.

Vikash Kumar Singh || www.singhvikash.in
Post #1341541
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse