Delay Validation
Determines if generated SSIS packages use delayed validation for metadata validation.
The value is emitted as the DelayValidation property on the data flow tasks and the generated connections (including the flat file connections used for file exports), so validation runs when each task executes instead of when the package starts.
When to Change This Setting
Keep the default Y for the generated load patterns, where objects a task depends on — staging tables, export files — may only exist once earlier tasks have created them. Disable it to have every task and connection validated up front when the package starts.
Related Settings
| Setting | Interaction |
|---|---|
| Validate External Metadata | Controls whether component metadata is validated against external sources at all |
Notes
- This setting is part of the SSIS settings category.
- The default value for this setting is
Y.