3

while runnig the ssis package i'm calling sp in the ADO.net source,but getting this error Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I have set the command timeout to 0(infinite time),but still getting the error.The sp is working fine in sql server and taking approx 31 seconds for executing it,but in ssis its throwing error..please help me on this.Thanks in advance.

Gurpreet Singh
  • 197
  • 3
  • 6
  • 14
  • Check out [this post](http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/eeff8fe6-620d-425e-b939-08c2cb66e3e2). It turns out you may see a timeout error when it's really a truncation error. Also, you can extend the client timeout, but still hit a server timeout. Extending the server timeout uses syntax like `EXEC sp_configure 'remote query timeout', 6000` – criticalfix May 20 '13 at 16:35

3 Answers3

2

Check out this bug report - there is a sp in the SSISDB database in SQL Server 2012 causing packages to time out before they start running. I had error message "Failed to execute IS server package because of error 0x80131904" and "Description: The operation failed because the execution timed out" when calling multiple (more than 10) packages from my scheduling tool via DTExec. Please vote for the issue on the connect site so that MS can release an official fix.

dragonspeare
  • 41
  • 3
1

Today, I was experiencing the same error while using the ADO Net Source, my sp works fine on the SSMS, but fails in the package, while In the package, it errors our with a long laundry list of errors, but basically it is timing out.

Solution is Right click on the ADO Net Source - Show Advanced Editor - Component Properties - Custom Properties - CommandTimeout - Increase the time here

Pierre.Vriens
  • 2,117
  • 75
  • 29
  • 42
Sucharitha Majji
  • 11
  • 1
0

I had the same problem in SSAS.

The way I sorted this out was extending the client and server time out settings. you can see more details in the link below:

routine to backup ssas databases fails with: The XML for Analysis request timed out before it was completed

Community
  • 1
  • 1
Marcello Miorelli
  • 3,368
  • 4
  • 44
  • 67