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
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,308 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,357 questions
1 answer
Sort by: Most helpful
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator
2023-05-03T12:31:28.5533333+00:00