Jaa


IDTSOutputColumnCollection90.SetIndex Method

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

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

Syntax

'Declaration
<DispIdAttribute(19)> _
Sub SetIndex ( _
    <InAttribute> lOldIndex As Integer, _
    <InAttribute> lNewIndex As Integer _
)
[DispIdAttribute(19)] 
void SetIndex (
    [InAttribute] int lOldIndex,
    [InAttribute] int lNewIndex
)
[DispIdAttribute(19)] 
void SetIndex (
    [InAttribute] int lOldIndex, 
    [InAttribute] int lNewIndex
)
/** @attribute DispIdAttribute(19) */ 
void SetIndex (
    /** @attribute InAttribute() */ int lOldIndex, 
    /** @attribute InAttribute() */ int lNewIndex
)
DispIdAttribute(19) 
function SetIndex (
    lOldIndex : int, 
    lNewIndex : int
)

Parameters

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

Remarks

lOldIndex and lNewIndex are zero-based parameters. This method moves the IDTSOutputColumn90 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

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

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