title: SSIS 2012 package takes long time in pre-execute phase
body: <p>We have a SSIS package in which the DFT is taking long time to load the data , the data is very less and when we run the query in SSMS it completes in seconds.</p>
  
  <p>When we checked the execution report found out that pre-execute phase is taking long time. For example it took 39 min and then the execution completed within seconds.</p>
  
  <p>2014-10-14 <strong>00:07:06.8913781</strong> -07:00 DFT_LOAD_PRJ_SAR_NON_COMPL_FACT:Information: Execute phase is beginning.</p>
  
  <p>2014-10-13 <strong>23:28:04.6633606</strong> -07:00 DFT_LOAD_PRJ_SAR_NON_COMPL_FACT:Information: Pre-Execute phase is beginning.</p>
  
  <p>2014-10-13 <strong>23:28:04.6545721</strong> -07:00 DFT_LOAD_PRJ_SAR_NON_COMPL_FACT:Information: Prepare for Execute phase is beginning.</p>
  
  <p>We have validated that the connection managers for OLE DB sources are all set to DelayValidation ( = True) and checked that ValidateExternalMetadata is set to false</p>
  
  <p>Please advise on the same.</p>