How to use delay validation

Question

How to use delay validation and when？

Answer 1

Hi @Jefferson ,

DelayValidation Property is available on Task level, Connection Manager, Container and on Package level. By default the value of this property is set to false that means that when the package start execution, It validates all the Tasks, Containers, Connection Managers and objects( Tables,Views, Stored Procedures etc.) used by them. If any object such as table or destination file etc. is not available then Package validation fails and Package stop execution.

By setting this property to True, We enforce our SSIS Package not to validate that Task, Connection Manager or entire Package at start but validate at run time. Let me explain with some real time examples

You may refer to ssis-what-is-delay-validation-property.html for details.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.