Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SSIS - Delay Validation Property can delay the validation of package until execution

Mar 24 2012 12:00AM by Alpesh Gorasia   

In general the package will be validated during design time itself. However, we can control this behavior by using "Delay Validation" property.

Default value of this property is false. It means that all actions taking place on the designer pane will be validated and checked for their correctness. By setting delay validation to true, we can delay validation of the package until run time.

Read More..   [440 clicks]

Published under: General Technology Tips ·  ·  ·  · 


Alpesh Gorasia
131 · 1% · 392
6
 
3
 
 
 
0
Interesting
 
0
Forgotten



Submit

2  Comments  

  • Alpesh, This is partially correct. Delay Validation does not just disable validation during design time, but when ever the package is executed it delays the validation at the Validation phase to Execute phase.

    commented on Mar 24 2012 9:57AM
    Sudeep Raj
    12 · 13% · 4303
  • By default run-time validation occurs in two phases:

    1) Package-level validation (or 'early validation') - occurs when the Runtime calls the Excecute method of a package. EVERYTHING in the package gets validated.

    If validation succeeds and the package commences its execute phase we come to

    2) Component-level validation (or 'late validation') - occurs when the Runtime calls the Execute method for each and every task within the package.

    This means that by default, all tasks within a package are validated twice!

    As well as affecting the design-time validation of package components, 'Delay Validation = True' disables the Early Validation (package-level) phase so that only Component-Level validation occurs at run-time. NOTE that it's not possible to disable Component-level validation.

    In general, delaying validation of all your components once you've finished development and are ready to deploy is a good option. It reduces overall package execution time (as early validation is skipped) and makes opening the package for editing less painful (as you don't need to wait for all the components to validate). Obviously, you may have scenarios where you want early validation to occur which is why I say in general so don't blindly delay validation without first considering the effect it will have on your package.

    commented on Jul 6 2012 4:47AM
    a.diniz
    311 · 0% · 139

Your Comment


Sign Up or Login to post a comment.

"SSIS - Delay Validation Property can delay the validation of package until execution" rated 5 out of 5 by 6 readers
SSIS - Delay Validation Property can delay the validation of package until execution , 5.0 out of 5 based on 6 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]