Поделиться через


IDTSExternalMetadataColumnCollection90.SetIndex Method

Changes the location in the collection of an IDTSExternalMetadataColumn90 object.

Пространство имен: Microsoft.SqlServer.Dts.Pipeline.Wrapper
Сборка: Microsoft.SqlServer.DTSPipelineWrap (in microsoft.sqlserver.dtspipelinewrap.dll)

Синтаксис

'Декларация
<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
)

Параметры

  • lOldIndex
    The current location in the collection of the column.
  • lNewIndex
    The new location of the column.

Замечания

lOldIndex and lNewIndex are zero-based parameters. The method moves the IDTSExternalMetadataColumn90 column located at lOldIndex to the location in the collection specified by lNewIndex. Any columns after lOldIndex are shifted up in the collection until reaching lNewIndex.

As an example, consider an external metadata column collection with the following IDs for the 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

  • If either lOldIndex or lNewIndex are outside the bounds of the collection, a Microsoft.SqlServer.Dts.HResults.DTS_E_INVALIDINDEX exception occurs.

Синхронизация потоков

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

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