SSIS package no longer running in 64 bit mode.

David Cohen 0 Reputation points
2024-01-31T21:55:14.46+00:00

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,408 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 30,411 Reputation points
    2024-02-01T05:16:22.2+00:00

    Hi @David Cohen,

    Please check your SSIS agent job via Advanced tab to see if you have chosen to run in 32-bit mode. User's image Regards,

    Zoe Hui


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

    0 comments No comments

  2. Olaf Helper 38,861 Reputation points
    2024-02-01T07:02:36.9566667+00:00

    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


  3. ZoeHui-MSFT 30,411 Reputation points
    2024-02-06T01:51:49.15+00:00

    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.