August 3, 2012 at 3:33 am
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?
August 7, 2012 at 2:14 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply