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.
Thank you so much for highlighting the fact about SSIS and related packages designed in a way to look ahead and gather more resources for technical operations.
ReplyDeleteSSIS Postgresql Write