CODEWITHSUNDEEP
ssisoledbetlsql-server-agentsql-job
malue
malue

Reputation: 59

SSIS Package is not executing from SQL Agent Job

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?

Upvotes: 2

Views: 1038

Answers (2)

speedinfusion
speedinfusion

Reputation: 385

Make sure you have 32 bit checked in your advanced configuration in the steps enter image description here

enter image description here

Upvotes: 2

J Sidhu
J Sidhu

Reputation: 677

  • It is easy to miss replacing local addresses like C:.. in your connections with network addresses when the job is ready to be scheduled. Sql Agent will need a UNC(network path) eg. \servername\folder\excelfile.xlsx

  • Look at the Sql Server agent service running on the server and
    identify the account. Provide access to above network share to this
    account.

Upvotes: 1

Related Questions