![]() ![]() "The Access Database Engine 2016 Redistributable is not intended:" I've done some reading of the documentation and they clearly have a multithreaded limitation I've noticed that it happens more frequently when we have multiple excel extracts going on concurrently across agent processes (10+ Excel loads in one package is okay, but 1 Excel load in 10 different packages, which are scheduled at the same time in sql job agent can occasionally hit the Unexpected Termination) At worst we could try restarting the box hosting the SSIS executions. Generally it clears up with restarting the ssis package via the SQL Job Agent. The issue I'm now trying to troubleshoot is, when reading excel files in SSIS, we occasionally get an Unexpected Termination in the SSISDB logs. For some background, we've grown our Business Intelligence team on using the SQL Server stack of tools (SQL Server 2019 Enterprise, SSIS, SSAS, SSRS & SQL Server Agent for scheduling jobs) from a handful of ETL jobs to generate a cube to now more than 50+ cubes with some jobs taking multiple hours to run (bulk loading dataflows with 100+million rows with upwards of 50+ lookup tasks is one example of one of the heavier modeling jobs). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |