SQl Server Agent "Unexpected Termination" with no error details

Dan Gallagher 6 Reputation points
2022-07-13T12:04:38.75+00:00

Hi,

I have built an SSIS project where one main package refers to and carries out over 30 other packages in succession. Each package does the same job - uses an excel sheet as a source to then update the same data stored in a SQL Server database table. Once the data is updated (new records added existing ones updated) the excel sheet is deleted and then created again using the data from the database table. Every step in the SSIS packages completes before moving onto the next step, as far as I'm aware it shouldn't be accessing / writing to the same source file at the same time

This has been executed on our development server manually (still to attempt running as a scheduled job on our dev server) and has worked fine. However when running this on our test server using a test SQL server agent test service account the process only goes so far until it stops due to an "Unexpected termination". I doubt permissions are the problem as the excel files are stored in one single folder and the process manages to succeed until when it stops. So up until this point the execution has successfully managed to access the source files and the database without any problems.

I've tried getting it to create a dump file but has given no further useful information other than a possible exception in the mini dump file mentioning ISServerExec.exe and a code of 0xC0000005. I have had something similar happen before when sourcing from Excel files for a different SSIS project in the end we switched to CSV files and the "Unexpected termination" hasn't happened since. Would love to change sources to CSV but would mean rewrite of entire SSIS project.

Thanks for any help or suggestions as I'm out of ideas.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,202 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,591 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Tom Phillips 17,721 Reputation points
    2022-07-14T14:31:22.233+00:00

    0xC0000005 is a memory access violation. This is almost always caused by code errors.

    Please make sure you have the latest CU installed. Although it is possible to be caused by an external driver.

    https://video2.skills-academy.com/en-US/troubleshoot/sql/general/determine-version-edition-update-level

    0 comments No comments