Compartir a través de


IDTSInputColumn100.SortKeyPosition Propiedad

Gets the sort key of an input column.

Espacio de nombres:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Ensamblado:  Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)

Sintaxis

'Declaración
ReadOnly Property SortKeyPosition As Integer 
    Get
'Uso
Dim instance As IDTSInputColumn100 
Dim value As Integer 

value = instance.SortKeyPosition
int SortKeyPosition { get; }
property int SortKeyPosition {
    int get ();
}
abstract SortKeyPosition : int
function get SortKeyPosition () : int

Valor de la propiedad

Tipo: System.Int32
An Integer that specifies the sort key of the column.

Comentarios

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.

Vea también

Referencia

IDTSInputColumn100 Interfaz

Espacio de nombres Microsoft.SqlServer.Dts.Pipeline.Wrapper