KB2993859 - FIX: "Unexpected termination" error in SQL Server Agent job that schedules an SSIS 2014 package running every minute

Applies To
SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use)

Symptoms

Assume that you have a Microsoft SQL Server 2014 Integration Services (SSIS 2014) package that contains Execute Package tasks. The package is scheduled to run one time every minute by using SQL Server Agent job. In this situation, the package fails intermittently, and you receive the following error message:

Note

Unexpected Termination

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Recommendation: Install the latest cumulative update for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

      

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.