ETL packages failed intermittently due to cloud destination connection, i.e., login timeout expired or other application/system error

lw 0 Reputation points
2023-05-03T12:07:16.6133333+00:00

SQL Server 2019

SSIS 13 & 15

Azure SQL Database
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.
4,555 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 33,176 Reputation points MVP
    2023-05-03T12:31:28.5533333+00:00

    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.

    0 comments No comments