August 6, 2014 at 9:01 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply