Recently I started to get this error from time to time on my nightly SSIS jobs: Message
Executed as user: “my user name”. Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 64-bit Copyright (C) 2016 Microsoft. All rights reserved. Started: 00:01:01 Failed to execute IS server package because of error 0x80131904. Server: “my server name”, Package path: “my package path.dtsx”, Environment reference Id: NULL. Description: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Source: .Net SqlClient Data Provider Started: 00:01:01 Finished: 00:01:31 Elapsed: 30.61 seconds. The package execution failed. The step failed.
Usually my job finishes successfully but this keeps happening from time to time.
I am using SQL Server agent.
On my package all timeouts are set to 0 (no timeout). Server remote timeout is set to 600.
No jobs are running at the time I want to start this one except SSIS Server Maintenance Job (same situation on failures and successful job finishes).
There are some similar questions but most of them are not answered and the rest failed to help me.
Thank You in advance!