Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 9:33 AM
Points: 407, Visits: 968
SSIS 2008
running on 2008 R2 x64

Error:
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