How to use delay validation

Jefferson 161 Reputation points
2022-12-30T01:49:02.013+00:00

How to use delay validation and when?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,854 questions
No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2022-12-30T01:56:27.73+00:00

    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.

    No comments

0 additional answers

Sort by: Most helpful