Validate External Metadata
Determines if generated SSIS packages validate external metadata.
The value is emitted as the ValidateExternalMetadata property on the source components of the generated data flows. When disabled, the components skip validating their column metadata against the external source at design and validation time.
When to Change This Setting
Keep the default Y so metadata mismatches between the model and the source surface as validation errors before rows flow. Disable it when the referenced external objects are not reliably available at validation time.
Related Settings
| Setting | Interaction |
|---|---|
| Delay Validation | Defers validation to execution time rather than skipping external metadata checks |
Notes
- This setting is part of the SSIS settings category.
- The default value for this setting is
Y.