IDTSInputColumn90.SortKeyPosition Property

Gets the sort key of an input column.

Espace de noms: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly: Microsoft.SqlServer.DTSPipelineWrap (in microsoft.sqlserver.dtspipelinewrap.dll)

Syntaxe

'Déclaration
<DispIdAttribute(123)> _
ReadOnly Property SortKeyPosition As Integer

[DispIdAttribute(123)] 
int SortKeyPosition { get; }

[DispIdAttribute(123)] 
property int SortKeyPosition {
    int get ();
}

/** @property */
/** @attribute DispIdAttribute(123) */ 
int get_SortKeyPosition ()

DispIdAttribute(123) 
function get SortKeyPosition () : int

Valeur de propriété

An Integer that specifies the sort key of the column.

Notes

Texte mis à jour :17 juillet 2006

A non-zero SortKeyPosition value for a column indicates that rows are sorted on the column. A positive value indicates an ascending sort; a negative value indicates a descending sort. SortKeyPosition values must represent a numeric sequence, starting with 1 and incremented by 1. The absolute value of a negative number determines its place in the sequence.

The IsSorted and SortKeyPosition properties work together to inform other components in the data flow that the data received in an input is already sorted in the order specified by the value of the SortKeyPosition of the input columns. These properties do not cause any sorting to occur.

Sécurité des threads

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

IDTSInputColumn90 Interface
IDTSInputColumn90 Members
Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace