Gets or sets a value that controls whether a component validates its column metadata against its external data source at design time.
Assembly: Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)
When this property is true, the component connects to its external data source during design time and validates the columns in its input or output collections against the columns at the external data source.
When set to false, the component does not perform this "connected" validation, but validates its input and output columns against the columns in the IDTSExternalMetadataColumnCollection100 collection, if the developer has implemented this functionality.
When running a package with DTC transactions (TransactionOption property = required) and validating external metadata in data flow components (ValidateExternalMetadata property = true), the package can hang under the following conditions: when other tasks already exist in the DTC transactions before the data flow is executed, and Table or view or Table name or view name variable is used as the data access method for an OLE DB Destination. In this scenario, the validation process will be blocked by other tasks which are already running. This is because connections used for the validation are never enlisted in the DTC transactions. This is by design. To avoid this situation, set the data flow component ValidateExternalMetadata property to false.