I have been getting an "Unexpected Termination" error from time to time on a bunch of SSIS jobs that I am running on a SQL Server 2016 instance (Microsoft SQL Server 2016 (RTM-CU2) (KB3182270) - 13.0.2164.0 (X64)). The server is a virtual server, running Windows Server 2012 R2, 4 processors and 52gb of ram.
I have a Master package/sub package project that is running around 200 packages in parallel. I have the Project set to run the default number of parallel processes, being 6.
The failures, when they do occur, appear to be pretty consistent. Basically, what is happening is the first 6 sub packages kick off. It appears to me that when it goes to pick up the next package the termination occurs.
I have checked the logs and I can't see anything written that is abnormal - there are no on warning or on error messages that are any different to if the packages run to completion. I can't see any other abnormal events in the servers event logs.
Does anyone have any clues on what may be happening, or any tips on how to fault find this issue?