Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-11-07 : 06:32:34
|
| 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:"I changed the job so that it is owned by administrator.Now the error is: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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-07 : 06:52:01
|
| where's the package stored? is it in d:/ of server or your local machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-07 : 07:02:00
|
| Dev and Prod have the same path.i.e. saved inside the following folder:\\servername\cFolder\ssis\packages\packagename.dtsx |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-07 : 07:05:24
|
quote:
Originally posted by arkiboys
Dev and Prod have the same path.i.e. saved inside the following folder:\\servername\cFolder\ssis\packages\packagename.dtsx
is the account running package been given access to above folder ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-07 : 07:17:42
|
| the administrator login ownes the job. and it has admin rights, so yes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-07 : 09:31:28
|
quote:
Originally posted by arkiboys
the administrator login ownes the job. and it has admin rights, so yes.
it has admin rights in server denoted by below path?\\servername\cFolder\ssis\packages\packagename.dtsx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-08 : 09:13:35
|
| solved. thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-08 : 09:26:46
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
running job