Export (0) Print
Expand All

IDTSExternalMetadataColumnCollection100 Interface

 

Applies To: SQL Server 2016 Preview

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

NameDescription
System_CAPS_pubpropertyCount

Gets the number of elements contained in an IDTSExternalMetadataColumnCollection100.

System_CAPS_pubpropertyIsUsed

Gets or sets a value that indicates whether the collection is populated by the component.

System_CAPS_pubpropertyItem[Object]

Gets the IDTSExternalMetadataColumn100 object specified by the Index parameter.

NameDescription
System_CAPS_pubmethodFindObjectByID(Int32)

Locates an object in the collection by its ID.

System_CAPS_pubmethodFindObjectIndexByID(Int32)

Locates the index of an object in the collection by its ID.

System_CAPS_pubmethodGetEnumerator()

Returns an enumerator that can iterate through an IDTSExternalMetadataColumnCollection100.

System_CAPS_pubmethodGetObjectByID(Int32)

Gets an IDTSExternalMetadataColumn100 object that has the specified ID.

System_CAPS_pubmethodGetObjectIndexByID(Int32)

Gets the index of an IDTSExternalMetadataColumn100 object that has the specified ID.

System_CAPS_pubmethodNew()

Creates a new IDTSExternalMetadataColumn100 object and adds it to the end of a collection.

System_CAPS_pubmethodNewAt(Int32)

Creates a new IDTSExternalMetadataColumn100 at the specified location in a collection.

System_CAPS_pubmethodRemoveAll()

Deletes each IDTSExternalMetadataColumn100 object in a collection.

System_CAPS_pubmethodRemoveObjectByID(Int32)

Removes an IDTSExternalMetadataColumn100 object that has the specified ID.

System_CAPS_pubmethodRemoveObjectByIndex(Object)

Removes an IDTSExternalMetadataColumn100 object at the specified index.

System_CAPS_pubmethodSetIndex(Int32, Int32)

Changes the location in the collection of an IDTSExternalMetadataColumn100 object.

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.

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

Community Additions

Show:
© 2015 Microsoft