title: SSIS pre-evaluation phase taking long
body: <p>I have a data flow that contains a OLEDB source (statement generated through a variable) which calls a stored procedure.
  In SSMS, it takes 8 minutes but the package itself takes 3 times longer to complete. 
  I've set the validation (DelayValidation) to true, so it still does it at run time. Ive also set the validation of the metadata in the data flow component, as well as in the connection manager. 
  The data flows have ReadUncommitted on them as well. 
  I`m not sure where else to look, any assistance on how to make this run faster would be great. </p>