I have a SSIS package which performs a few tasks using SQL Server Agent. First it executes a script task, then accesses Excel files, executes a SQL query and moves files to another directory.
The package worked fine when I executed it manually via debugger.
When I deployed the package and created an Agent job it fails on the excel connection task.
My implementation: - Excel files are located on a share stored on another account in the domain - the account which executes the package and runs agent jobs has permissions in the share and there is a proxy created for the credentials in the database
What are your suggestions to try? I spent a lot of time trying to fix it.