May 15, 2013 at 9:33 am
I have a ssis package with foreach loop.
The connection times out after some 50 files for processed when the loop is executed and it gets times out saying below error.
The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.". Possible failure reasons: Problems with the query, "ResultSet" property not set correcly
Can somebody please tell me what could be the issue and how to resolve?
May 23, 2013 at 12:27 pm
Any update on this ?
Below is the error description
Executing the query "stored proc name" failed with the following error: "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
May 23, 2013 at 12:39 pm
Multiple Active Result Sets (MARS) set to true
Malleswarareddy
I.T.Analyst
MCITP(70-451)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply