70-463 · Question #108
You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the following represents the…
The correct answer is D. Boolean. The ValidateExternalMetaData property in an SSIS data flow component is of type Boolean, controlling whether external metadata is validated against the data source at design time.
Question
You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the following represents the data type for this property?
Options
- AInteger
- BIDTSExternalMetadataColumn100
- CString
- DBoolean
How the community answered
(22 responses)- B5% (1)
- C5% (1)
- D91% (20)
Why each option
The ValidateExternalMetaData property in an SSIS data flow component is of type Boolean, controlling whether external metadata is validated against the data source at design time.
The property is not an Integer; it represents a binary true/false validation flag, not a numeric value.
IDTSExternalMetadataColumn100 is an interface representing an individual external metadata column object, not the data type of the ValidateExternalMetaData property itself.
The property is not a String; it cannot hold text values and strictly represents a binary on/off validation setting.
ValidateExternalMetaData is a Boolean property on SSIS data flow components. When set to True, the component validates its external metadata columns against the external data source at design time; when set to False, validation is skipped - useful when the source is unavailable during development.
Concept tested: SSIS data flow ValidateExternalMetaData property data type
Source: https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-custom-objects/data-flow/validating-a-data-flow-component
Topics
Community Discussion
No community discussion yet for this question.