Export (0) Print
Expand All

IDTSExternalMetadataColumnCollection100 Interface

Contains a collection of IDTSExternalMetadataColumn100 objects that represent the columns of an external data source.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

[DefaultMemberAttribute("Item")]
[GuidAttribute("EA1D54B3-800D-429A-BB65-E5921A02F886")]
[TypeLibTypeAttribute(TypeLibTypeFlags.FDual|TypeLibTypeFlags.FDispatchable)]
public interface IDTSExternalMetadataColumnCollection100 : IEnumerable

The IDTSExternalMetadataColumnCollection100 type exposes the following members.

  NameDescription
Public propertyCountGets the number of elements contained in an IDTSExternalMetadataColumnCollection100.
Public propertyIsUsedGets or sets a value that indicates whether the collection is populated by the component.
Public propertyItemGets the IDTSExternalMetadataColumn100 object specified by the Index parameter.
Top

  NameDescription
Public methodFindObjectByIDLocates an object in the collection by its ID.
Public methodFindObjectIndexByIDLocates the index of an object in the collection by its ID.
Public methodGetEnumeratorReturns an enumerator that can iterate through an IDTSExternalMetadataColumnCollection100.
Public methodGetObjectByIDGets an IDTSExternalMetadataColumn100 object that has the specified ID.
Public methodGetObjectIndexByIDGets the index of an IDTSExternalMetadataColumn100 object that has the specified ID.
Public methodNewCreates a new IDTSExternalMetadataColumn100 object and adds it to the end of a collection.
Public methodNewAtCreates a new IDTSExternalMetadataColumn100 at the specified location in a collection.
Public methodRemoveAllDeletes each IDTSExternalMetadataColumn100 object in a collection.
Public methodRemoveObjectByIDRemoves an IDTSExternalMetadataColumn100 object that has the specified ID.
Public methodRemoveObjectByIndexRemoves an IDTSExternalMetadataColumn100 object at the specified index.
Public methodSetIndexChanges the location in the collection of an IDTSExternalMetadataColumn100 object.
Top

A data flow component populates and uses this collection to validate the columns in its IDTSInputColumnCollection100 or IDTSOutputColumnCollection100 when the ValidateExternalMetadata property is false or when the SSIS Designer is in offline mode.

The collection typically represents the columns of an external data source used by a source or destination component. Use of the collection allows the component to perform validation without an expensive, time-consuming round trip to the source itself.

For more information about implementing external metadata columns in components see Implementing External Metadata.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft