Unexpected termination - SSIS 2019 export to excel files

JulieYing-2010 10 Reputation points
2023-04-25T20:22:35.09+00:00

I have a SSIS 2019 project, which contains a main package and a few child packages that may export data to excel files (using Excel 2007-2010). The main package calls the child packages based on criteria. The excel files are dynamically generated though they use fixed file templates. If I ran the packages from my local computer, they work totally fine. However, if the packages were executed from the server, it could fail with "Unexpected Termination" error when the data was exported to multiple excel files. The bizarre thing is that it didn't fail all the time. Sometimes it might succeed. I checked all the logs (windows, SQL Server, SSIS, ...) but found no error messages anywhere. If the data is exported to only one excel file, it won't fail. The server has "Microsoft Access Database Engine 2016 Redistributable - 64bit" installed. I have tried the 32bit version, which didn't work. Does anybody have any related solution? Or is this a bug in the "Access Database Engine 2016 Redistributable"? Thanks.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
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
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,836 Reputation points
    2023-04-26T05:39:45.8166667+00:00

    Hi @JulieYing-2010,

    Unexpected termination

    It is general and a bit hard for us to narrow down the issue.

    If it works fine in VS but only will fail in agent job, you may have a check here.

    SSIS package does not run when called from a SQL Server Agent job step

    Regards,

    Zoe Hui


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