Could you try to add a retry logic on your SSIS packages using the recommendations provided on this article? Transient errors may be the cause of the intermittent errors when SSIS packages access cloud resources (databases) and a retry logic should take care of those errors and allow the SSIS packages to finish successfully.
ETL packages failed intermittently due to cloud destination connection, i.e., login timeout expired or other application/system error

lw
0
Reputation points
SQL Server 2019
SSIS 13 & 15