I'm trying to work out what permissions I need to give a user in order to
create, deploy and execute a 2005 package from a job. I have a local account
machine\TestDev that has a login to the server (TestDev) with db_dtsltduser,
db_dtsoperator and SQLServerAgent User roles in msdb. I have a second local
account called machine\TestProxy which is tried to the TestProxy credential
which is associated with the TestProxy proxy account which as the SSIS
subsystem selected. TestDev is a principal for the TestProxy account and the
TestProxy account has permission to an OS share where I am trying to write a
file. TestDev can create the package, save it to sql server, created a job
with an SSIS step that calls the package and uses the TestProxy to run, but I
am getting a "Executes as user machine\TestProxy. The Package could not be
loaded. The step failed" error. I have no idea what other permissions what
account needs to do this and can find absolutely no information on this side
of it. Any help is appreciated

I found the missing piece in case anyone else has this problem. the windows
account used to create the credential for the proxy must also have a login to
sql server with the db_dtsoperator role in msbd.

jaime

"Jaime" wrote: