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
	Count	Gets the number of elements contained in an IDTSExternalMetadataColumnCollection100.
	IsUsed	Gets or sets a value that indicates whether the collection is populated by the component.
	Item	Gets the IDTSExternalMetadataColumn100 object specified by the Index parameter.

Top

Methods

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

See Also

Reference

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace