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.
5,357 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator
    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.