I am using CheckPointFile and the following properties i have set in my package.
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.
Error: 2012-08-03 08:34:23.24
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?