DtsConvert.VarTypeFromTypeCode Method

Converts a system TypeCode to a Integration ServicesVariant data type. This method is not CLS-compliant.

命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

语法

声明
Public Shared Function VarTypeFromTypeCode ( _
    typeCode As TypeCode _
) As UShort

public static ushort VarTypeFromTypeCode (
    TypeCode typeCode
)

public:
static unsigned short VarTypeFromTypeCode (
    TypeCode typeCode
)

public static UInt16 VarTypeFromTypeCode (
    TypeCode typeCode
)

public static function VarTypeFromTypeCode (
    typeCode : TypeCode
) : ushort

参数

• typeCode
  The system TypeCode to convert to the SSIS type.

返回值

The SSIS type for the system TypeCode.

备注

For a list of the SSIS types, see Integration Services 数据类型.

The following table shows the TypeCode and what SSIS Variant data type they are converted to.

示例

The following example shows a pipeline component that overrides the RegisterEvents method and creates a custom event using the EventInfos collection, using the VarTypeFromTypeCode to create a reference type.

Public override void RegisterEvents()
{
string []parameters = new string[1]{"Parameter1"};
ushort []types = new ushort[1]{DtsConvert.VarTypeFromTypeCode(TypeCode.String)};
string []descriptions = new string [1]{"The first parameter."};

EventInfos.Add("OnPreExecute", "Fires when the PreExecute method runs.", false, ref parameters, ref types, ref descriptions);
}

Public Overrides  Sub RegisterEvents()
String ()parameters = New String(1)
{
    "Parameter1"
}

System.UInt16 ()types = New System.UInt16(1)
{
    DtsConvert.VarTypeFromTypeCode(TypeCode.String)
}

String ()descriptions = New String (1)
{
    "The first parameter."
}

 
EventInfos.Add("OnPreExecute", "Fires when the PreExecute method runs.", False,  parameters,  types,  descriptions)
End Sub

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

DtsConvert Class
DtsConvert Members
Microsoft.SqlServer.Dts.Runtime Namespace