Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IDTSExternalMetadataColumn100 Interface

 

Applies To: SQL Server 2016 Preview

Represents a column from an external data source.

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

[<TypeLibTypeAttribute(TypeLibTypeFlags.FDual | TypeLibTypeFlags.FDispatchable)>]
[<GuidAttribute("FCB1DDF9-F9B3-4958-8E98-E42109F418A4")>]
type IDTSExternalMetadataColumn100 = 
    interface
        interface IDTSObject100
    end

NameDescription
System_CAPS_pubpropertyCodePage

Gets or sets the character set used to interpret the data contained in the column.

System_CAPS_pubpropertyCustomPropertyCollection

Gets the custom property collection of the external metadata column.

System_CAPS_pubpropertyDataType

Gets or sets the DataType of the column.

System_CAPS_pubpropertyDescription

Gets or sets the descriptive text for the IDTSExternalMetadataColumn100 object.

System_CAPS_pubpropertyID

Gets or sets the ID of the IDTSExternalMetadataColumn100.

System_CAPS_pubpropertyIdentificationString

Gets the String that uniquely identifies the IDTSExternalMetadataColumn100 object in the data flow.

System_CAPS_pubpropertyLength

Gets or sets the length of the external metadata column.

System_CAPS_pubpropertyMappedColumnID

Gets or sets the ID of a column that is mapped to the IDTSExternalMetadataColumn100 object.

System_CAPS_pubpropertyName

Gets or sets a String that contains the name of the IDTSExternalMetadataColumn100.

System_CAPS_pubpropertyObjectType

Returns the value from the DTSObjectType enumeration that corresponds to an external metadata column.

System_CAPS_pubpropertyPrecision

Gets or sets the number of decimal places stored by an external metadata column that has a decimal data type.

System_CAPS_pubpropertyScale

Gets or sets the number of digits stored by an external metadata column that has a decimal data type.

The IDTSExternalMetadataColumn100 column represents a column in a remote data source. It contains the same properties as the external data column. This allows components to validate the columns in their IDTSInput100 and IDTSOutput100 column collections when the external data source itself is unavailable, or when a round trip to the external source is undesirable.

Return to top

Community Additions

Show:
© 2015 Microsoft