, 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?