Errors Deploying An SSIS Package

Hi All,

I hope someone can help becuase this problem is issue us several headaches.

We are currently trying to deploy an SSIS package to a production server. The deployment goes fine, the package runs ok when executed manually. The issues start when we try and execute it under the SQL agent.

Having gone back to the drawing board and spent much of the day reading various articles and applying the various options (especially those within the MS KB article 918760), we are still no closer to a resolution.

The SSIS package was created under an Administrator, and the SQL agent runs under a different Domain Admin account.

When we set up the Schedule to read from SQL Server or the SSIS Store the standard "Executed as user: DOMAINUSERNAME. The package execution failed. The step failed" in the history.

We tried to create the package as a file access and now get "Package could not be found" even though you can browse to i in the schedule list. The Domain account as full access to the folder where the package resides.

Has anyone else come across this issue, or have a workable solution?

Many TIA.