Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Package connection timeouts Expand / Collapse
Posted Wednesday, August 6, 2014 9:01 AM



Group: General Forum Members
Last Login: Monday, December 5, 2016 10:27 AM
Points: 430, Visits: 1,054
SSIS 2008
running on 2008 R2 x64

System.InvalidOperationException: 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.

We've been running into this error quite a bit lately.
This particular package is using a suite of custom built components for handling logging, error handling, data auditing, etc.... this creates a lot of connections within the package.
I've been looking into the RetainSameConnection property and setting that to True so it shares 1 connection rather than creating a bunch of new ones. this is failing during validation not execution.

Looking for any thoughts on the use of this property or on this error... any comments are appreciated

thanks - Tom
Post #1600267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse