Share via


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)

Syntax

'Declaration
<GuidAttribute("E472B6AE-202C-4C67-8F44-7D7EE3807A44")> _
Public Interface IDTSExternalMetadataColumnCollection100 _
    Inherits IEnumerable
'Usage
Dim instance As IDTSExternalMetadataColumnCollection100
[GuidAttribute("E472B6AE-202C-4C67-8F44-7D7EE3807A44")]
public interface IDTSExternalMetadataColumnCollection100 : IEnumerable
[GuidAttribute(L"E472B6AE-202C-4C67-8F44-7D7EE3807A44")]
public interface class IDTSExternalMetadataColumnCollection100 : IEnumerable
[<GuidAttribute("E472B6AE-202C-4C67-8F44-7D7EE3807A44")>]
type IDTSExternalMetadataColumnCollection100 =  
    interface
        interface IEnumerable
    end
public interface IDTSExternalMetadataColumnCollection100 extends IEnumerable

The IDTSExternalMetadataColumnCollection100 type exposes the following members.

Properties

  Name Description
Public property Count Gets the number of elements contained in an IDTSExternalMetadataColumnCollection100.
Public property IsUsed Gets or sets a value that indicates whether the collection is populated by the component.
Public property Item Gets the IDTSExternalMetadataColumn100 object specified by the Index parameter.

Top

Methods

  Name Description
Public method FindObjectByID Locates an object in the collection by its ID.
Public method FindObjectIndexByID Locates the index of an object in the collection by its ID.
Public method GetEnumerator() (Inherited from IEnumerable.)
Public method GetEnumerator() Returns an enumerator that can iterate through an IDTSExternalMetadataColumnCollection100.
Public method GetObjectByID Gets an IDTSExternalMetadataColumn100 object that has the specified ID.
Public method GetObjectIndexByID Gets the index of an IDTSExternalMetadataColumn100 object that has the specified ID.
Public method New Creates a new IDTSExternalMetadataColumn100 object and adds it to the end of a collection.
Public method NewAt Creates a new IDTSExternalMetadataColumn100 at the specified location in a collection.
Public method RemoveAll Deletes each IDTSExternalMetadataColumn100 object in a collection.
Public method RemoveObjectByID Removes an IDTSExternalMetadataColumn100 object that has the specified ID.
Public method RemoveObjectByIndex Removes an IDTSExternalMetadataColumn100 object at the specified index.
Public method SetIndex Changes the location in the collection of an IDTSExternalMetadataColumn100 object.

Top

Remarks

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.