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 Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
507 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.
3,092 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 27,461 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