November 7, 2011 at 5:35 am
Hi,
In Dev, there is a job which executes a ssis package.
The group "sqlgroup" can run this job in Dev and works fine.
The view history in Dev shows "Executed as user: servername\SYSTEM"
When running the same job in Prod, the job fails.
The view history shows:
"Could not load package "\File System\PackageName" because of error 0x80070005. Description: Access to the path 'D:\Program Files\Microsoft SQL Server\100\DTS\Packages\PackageName.dtsx' is denied."
Any thoughts please?
Thanks
November 7, 2011 at 5:40 am
Apparently, the account that SQL Server Agent uses to execute jobs on the production server doesn't have sufficient rights to access the folder where the package is located.
Either give that account more permissions, or create a proxy that the SQL Server Agent can use for that specific job.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 7, 2011 at 5:47 am
I guess "\File System\PackageName" refers to "'D:\Program Files\Microsoft SQL Server\100\DTS\Packages\PackageName.dtsx'"
??
November 7, 2011 at 6:05 am
It does. You have two options to store packages on the file system:
* in the SSIS package store: this is a specific secured folder in the SQL Server directory. In your case D:\Program Files\Microsoft SQL Server\100\DTS\Packages
* somewhere else on the file system
So probably your packages are stored in the SSIS package store, and possibly the SQL Server Agent account doesn't have permission to access this folder.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 8, 2011 at 7:12 am
Solved. thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply