I am running SQL Server 2005 on a clustered Windows 2003 Server. I
have a very simple SSIS package that I want to run as a scheduled job. I
created a proxy and gave the proxy SSIS package execution rights and told
the job to run the execution step as the proxy.

In the connection manager in SSIS I use credentials with sysadmin and
db_dtsoperator (in msdb) rights.

When I go to run the package the error tells me the login failed for the
user credentials in the connection manager. Should it not be using the
proxy? By default if a login has sysadmin rights they can automatically use
the proxy, yes?

I have changed the job owner to several different users with admin rights
but it still fails to login successfully. The only time the scheduled job
will run is if I've used the SQLAdmin user rights in the connection manager.

I've tried this with the package saved as a file and to SQL Server.

Any thoughts would be appreciated.

Christie