SSIS package failed with Application: ISServerExec.exe,Framework Version: v4.0.30319

pradeep kotha 0 Reputation points
2023-09-06T16:05:09.52+00:00

, I found SSIS package is failing with the below .Net Runtime

Application: ISServerExec.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
   at Microsoft.SqlServer.XEvent.Configuration.SessionConfiguration.!SessionConfiguration()
   at Microsoft.SqlServer.XEvent.Configuration.SessionConfiguration.Dispose(Boolean)
   at Microsoft.SqlServer.XEvent.Configuration.SessionConfiguration.Finalize()

error in SQL server 2019. SSIS packages have been running fine for the last 8 months issue is triggered all of a sudden and It's working fine for some packages but failing for others. SQL and SSRS services is running with the service account and have sysadmin access Also, I checked all access related to the service account and it is part of the administrator group in all SQL servers. However, the SSIS job is running fine when we run it manually, but it is failing with the service account scheduled under the SQL job. Can you please suggest the answers to fix the above issue?

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,506 Reputation points
    2023-09-07T06:03:14.67+00:00

    Hi @pradeep kotha,

    Could you have a try to change the runtime in SQL Server Job Step properties to 32-bit mode?

    If this does not work, please create a proxy account which have the full permission to run the job.

    Regards,

    Zoe Hui


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