Need some help on the SSIS packages execution. We have around 20 packages that are executed all the same time (7:00 PM).
Microsoft (R) SQL Server Execute Package Utility Version 13.0.5598.27 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved.
Started: 6:19:12 PM Failed to execute IS server package because of error 0x80131904. Server: , Package path: , Environment reference Id: 5. Description: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=15024; handshake=10308;
We have tried executing these packages at 1 minute gap but still we are seeing 'Connection Timeout Expired' issue. On re run of these packages 30 minutes later all packages runs through fine.
Please suggest what other steps can be taken to identify the issue and address the actual issue which occurs at 7:00 PM.
User contributions licensed under CC BY-SA 3.0