Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS - CheckPointFile Expand / Collapse
Posted Friday, August 3, 2012 3:33 AM


Group: General Forum Members
Last Login: Wednesday, September 30, 2015 3:00 AM
Points: 168, Visits: 78
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

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
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 7, 2012 2:14 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:15 AM
Points: 79, Visits: 243
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 ||
Post #1341541
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse