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("290C88E9-1A96-4A2A-8F41-454B48AC90AE")> _
Public Interface IDTSExternalMetadataColumnCollection100 _
Inherits IEnumerable
'Usage
Dim instance As IDTSExternalMetadataColumnCollection100
[GuidAttribute("290C88E9-1A96-4A2A-8F41-454B48AC90AE")]
public interface IDTSExternalMetadataColumnCollection100 : IEnumerable
[GuidAttribute(L"290C88E9-1A96-4A2A-8F41-454B48AC90AE")]
public interface class IDTSExternalMetadataColumnCollection100 : IEnumerable
[<GuidAttribute("290C88E9-1A96-4A2A-8F41-454B48AC90AE")>]
type IDTSExternalMetadataColumnCollection100 =
interface
interface IEnumerable
end
public interface IDTSExternalMetadataColumnCollection100 extends IEnumerable
The IDTSExternalMetadataColumnCollection100 type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
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 | |
|---|---|---|
.gif "Public method") |
FindObjectByID | Locates an object in the collection by its ID. |
|
FindObjectIndexByID | Locates the index of an object in the collection by its ID. |
|
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.