Timeout error while working with Execute SQL task in SSIS
Hi, I am running a SSIS package i have some execute SQL Tasks in my package one of them i am using to execute my stored procedure usually the procedure itself takes more than 10 minutes to run successfully from Management Studio.In middle of the package execution at these Execute Sql task my package is kicked out by Visual studio stating that "Timeout Error" and also "Microsoft Visual Studio is Busy Restarting Now" Its weird. Actually i am running these package from long time without any error. Recently i am using Windows 7 server. Is there any problem due to Windows 7. I also un-check time out for query execution using Tools-->Options-->Table and Database Design--->Override connection string time-out for table designer updates: transaction time-out after: 30 seconds in BIDS. I don't understand the reason behind it. Sometimes its executing just fine. Please can someone help me in resolving these issue. latha
May 31st, 2011 3:40pm

Make sure in Properties Pane of ExecuteSql Task... Timeout property=0 or Max(1000000).
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2011 4:22pm

Yes, i did that. I set timeout to zero but no use. latha
May 31st, 2011 4:37pm

Have you checked the timeout in the Connection Manager within SSIS? And also check the timeout in SQL Server (in SSMS go to properties of server and see connection tab)Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 1st, 2011 1:32am

I am not yet schedule the package in the SQL Server Agent. I am running the package from BIDS itself.I already set the timeout for the connection manager within SSIS.latha
June 1st, 2011 10:03am

I am not yet schedule the package in the SQL Server Agent. I am running the package from BIDS itself.I already set the timeout for the connection manager within SSIS. latha OK, but check the timeout setting from your target database (in SSMS go to properties of server and see connection tab). There is a default timeout of 600 seconds (10 minutes).Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 1st, 2011 1:33pm

Yes, i have 600 seconds in my default timeout under connections for remote query timeout.latha
June 1st, 2011 2:11pm

Yes, i have 600 seconds in my default timeout under connections for remote query timeout. latha Change it to zero (or something longer than 10 minutes) and try again...Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
June 1st, 2011 2:19pm

I will give a try to these. I think its now not raising any problem. Thanks SSISJoost.latha
June 1st, 2011 2:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics