ssis - SSIS Package is not executing from SQL Agent Job

Question

I am trying to create a scheduled job, which should be executed daily at 23:15 o'clock.

If I execute my package from Visual Studio it is working fine and it fills my Excel-files. But this is only working, when I do it manually.

If I execute my package by a scheduled job, I get the following errors:

error messages

I found out, that I have to install "AccessDatabaseEngine" (x32) and but nevertheless my problems have not been solved.

Do you have any ideas to solve this?

标签： ssisoledbetlsql-server-agentsql-job

Answer 1

确保在步骤中的高级配置中检查了 32 位