March 31, 2014 at 3:22 pm
I have a simple SSIS package that retrieves data from a formatted Excel spreadsheet. The Stored Procedure has the appropriate permissions and executes correctly. xp_cmdshell is active and the user group has execute permissions. The spreadsheet source location has the permissions set. I am the originator of the package and it works correctly for me on any desktop in the domain. When another user tries to execute the SSIS package, the package exit code of 5 (The utility was unable to load the requested package. The package could not be loaded.) comes back.
msdb roles for db_ssisoperator, db_ssisadmin, and db_ssisltduser have been assigned to the user group.
What permission am I missing? This is getting frustrating.
Thanks in advance
Scott
April 1, 2014 at 10:29 am
What's the package protection level ?
--
SQLBuddy
April 1, 2014 at 11:58 am
Currently set to do not save sensitive data.
April 1, 2014 at 1:17 pm
Did you create a server proxy account for the non-sysadmin users to run XP_cmdshell ? Are you a sysadmin on the server and is it not possible to schedule the package to run by your ID ?
--
SQLBuddy
April 1, 2014 at 2:25 pm
1. This package is on-demand execution triggered from an application. Setting it as a job won't work.
2. I am sysadmin on the server. The users will be activating the process. This is the main issue.
3. Will a proxy fix this issue? I have used the login context before with other applications, and they are functioning correctly.
April 1, 2014 at 5:51 pm
Scott Nicholson-254313 (4/1/2014)
1. This package is on-demand execution triggered from an application. Setting it as a job won't work.2. I am sysadmin on the server. The users will be activating the process. This is the main issue.
3. Will a proxy fix this issue? I have used the login context before with other applications, and they are functioning correctly.
It could fix it .. First create the server proxy account (SSMS --> SQL Server Properties --> Security )
Check this
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx
--
SQLBuddy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply