We have a scheduled SQL Job which runs the SSIS package and process the files (Hourly Job, and 24 execution's daily). From past few weeks we are seeing minimum 2 failures in a day randomly, post failure also Job executes run fine in next execution cycle i.e = next hour.
Very recently we have upgraded our SSMS to 2019
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: [TIME] Error: [DATE TIME] Code: 0x00000005 Source: File count File count Description: Failed to compiled scripts contained in the package. Open the package in SSIS Designer and resolve the compilation errors. End Error Error: [DATE TIME] Code: 0x00000005 Source: File count File count Description: The directory is not empty. (Exception from HRESULT: 0x80070091) End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: [TIME] Finished: [TIME] Elapsed: #### seconds. The package execution failed. The step failed.