Metodo IDTSOutputColumnCollection100.SetIndex

Moves an output column to a new location in a collection.

Spazio dei nomi  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

Sintassi

'Dichiarazione
Sub SetIndex ( _
    lOldIndex As Integer, _
    lNewIndex As Integer _
)
'Utilizzo
Dim instance As IDTSOutputColumnCollection100 
Dim lOldIndex As Integer 
Dim lNewIndex As Integer

instance.SetIndex(lOldIndex, lNewIndex)
void SetIndex(
    int lOldIndex,
    int lNewIndex
)
void SetIndex(
    [InAttribute] int lOldIndex, 
    [InAttribute] int lNewIndex
)
abstract SetIndex : 
        lOldIndex:int * 
        lNewIndex:int -> unit
function SetIndex(
    lOldIndex : int, 
    lNewIndex : int
)

Parametri

  • lOldIndex
    Tipo: System.Int32
    The index of the output column to move.
  • lNewIndex
    Tipo: System.Int32
    The new location in the collection.

Osservazioni

lOldIndex and lNewIndex are zero-based parameters. This method moves the IDTSOutputColumn100 object located at lOldIndex to the location in the collection specified by lNewIndex. Any columns after lOldIndex are shifted up in the collection until lNewIndex is reached.

As an example, consider an output column collection with the following IDs for the output columns:

  • Col1

  • Col2

  • Col3

  • Col4

If SetIndex is called with lOldIndex equal to 0 and lNewIndex equal to 2, the modified collection has the following order:

  • Col2

  • Col3

  • Col1

  • Col4

Vedere anche

Riferimento

IDTSOutputColumnCollection100 Interfaccia

Spazio dei nomi Microsoft.SqlServer.Dts.Pipeline.Wrapper