Unexpected Termination of SSIS

Krunal Suthar 0 Reputation points
2023-08-04T11:12:26.15+00:00
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)

I have a SSIS package which inserts data from csv file to sql server table & We face issue of unexpected termination flag daily without any error message as you see in attached screenshot below and I have also mentioned our SQL Server version above.Screenshot_3

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,586 Reputation points
    2023-08-04T13:25:53.9+00:00

    Hi @Krunal Suthar,

    You are running very old RTM version of SQL Server 2019: 15.0.2000.5 build.

    It is highly recommended to install the latest CU21: 15.0.4316.3 build.

    Check it out here: https://sqlserverbuilds.blogspot.com/#sql2019x


  2. ZoeHui-MSFT 41,491 Reputation points
    2023-08-08T01:23:26.8633333+00:00

    Hi @Krunal Suthar,

    Try to re-deploy the package to sql server to see if could succeed or not.

    Regards,

    Zoe Hui


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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.