Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

[Anonymous]

Hi, When I try to execute complex query using SQL VBO GET CSV File action, I am getting the below timeout error. Usualy when I run the same query through SSMS it takes 25-35 minutes to get the results. Can someone help me to increase the timeout or is there any work around to fix this issue?   Error: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.     Thanks, Ram.

[Denis__Dennehy]

A quick internet search (very useful that www) suggests that maybe adding something like Connection Timeout=nn  (with nn being a number in seconds) to your connection string might be what you need to do.  The default is apparently something like 10 minutes but may differ from that depending upon your database server config.