SQL Agent Job and Integration Services Package Execution error
I have an SSIS Package deployed to an SSIS Package Store on SQL Server 2005 June CTP. The package executes successfully if I right click on it and click "Execute Package". The package also executes successfully through the dtexecui utility. Also, if I execute the package from a command prompt using dtexec and use a "runas" with the same credentials that the SQL Server Agent service is logged on as it executes successfully.
My problem is if I set up a SQL Agent Job and add a step to execute this same package the job fails with the error message "Package execution failed. The step failed". In the step properties the "RunAs" is set to the SQL Agent Service - which as I stated above - can execute the package successfully using dtexec.
Any help would be appreciated.
