SSIS package no longer running in 64 bit mode.

Question

I have an ssis package, that is deployed to the catalog and run as part of a sql job (sql server 2022). The job is no longer running. The package is giving the below error: An integration services class cannot be found. Make sure that integration services is correctly installed on the computer that is running the application. Also make sure that the 64 bit Version of Integration Services is installed if you are running a 64 bit application. I pulled the package from the catalog to test. It is no longer running in 64 bit mode, but will run in VS as 32bit. I'm not using any Excel connectors in the project. any ideas on how to solve this issue would be appreciated.

Answer 1

Hi @David Cohen,

Please check your SSIS agent job via Advanced tab to see if you have chosen to run in 32-bit mode. Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

That's only the message for the agent job with only less information. Instead review the SSIS package execution log report for more details, see https://learn.microsoft.com/en-us/sql/integration-services/performance/monitor-running-packages-and-other-operations?view=sql-server-ver16

Answer 3

Hi @David Cohen,

Please make sure that you have installed SSIS service on the machine.

In addition, you may re-deploy the package to SQL Server and check that you have set the target server correctly.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.