IDTSOutputColumnCollection100.SetIndex Método
Moves an output column to a new location in a collection.
Espacio de nombres: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Ensamblado: Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)
Sintaxis
'Declaración
Sub SetIndex ( _
lOldIndex As Integer, _
lNewIndex As Integer _
)
'Uso
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
)
Parámetros
- lOldIndex
Tipo: System.Int32
The index of the output column to move.
- lNewIndex
Tipo: System.Int32
The new location in the collection.
Comentarios
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