Saturday, December 31, 2016

Delay validation

SSIS validates package to ensure that they will execute properly.Sql server  validation occurs both as package is opened(design time validation) and just before the package executes(run time validation).

Design time validation can be performed by seting work offline option.
Run time validation can be stopped by setting delay validation property as true for the package, which will validate during run time.

Delay validation of a single component in Data flow can be set by setting property ValidateExternalMetaData property to false.

No comments:

Post a Comment