I am running SQL Server 2005 on a clustered (2 node) 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.

Any thoughts would be appreciated.

Christie