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!

  • is it a VM or a physical machine? – Stijn Wynants Dec 19 '17 at 14:52
  • When package is updated in Integration Services Catalogs, you need to check it in the job, to see if everything fine, eg. environment reference is set correctly. – Wendy Dec 19 '17 at 18:59
  • @StijnWynants , it is a physical machine – Tautvydas Versockas Dec 19 '17 at 19:34
  • @Wendy , how is that related to this issue? Since everything usually works fine. Even after the job failed I restared the job manually and it successfully completed without any problems. Package was not being updated at any time. – Tautvydas Versockas Dec 19 '17 at 19:38
  • Is there something in the sql server error log? – Stijn Wynants Dec 19 '17 at 20:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.