SSIS Validates each Data Flow when opening Solution - Delay Validation?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 13, 2012 at 3:04 pm

  #265765

  SSIS is Validating each Data Flow when I open a Solution.

  So far I have 20 of 179 Transformations and it is taking a long time already.

  How do I prevent this? Through Delay Validation?

  What are the consequences?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  March 13, 2012 at 7:59 pm

  #1458967

  Yes, you can set Delay Validation to true. The downside is you will not pickup on outdated metadata or broken connections until runtime.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 14, 2012 at 11:23 am

  #1459388

  Thanks!

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/