Package connection timeouts

• TangoVictor

  SSChampion

  Points: 10969

  More actions

  August 6, 2014 at 9:01 am

  #297624

  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