DtsConvert.TypeCodeFromVarType Method

Article
12/03/2008

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

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Shared Function TypeCodeFromVarType ( _
    varType As UShort _
) As TypeCode

public static TypeCode TypeCodeFromVarType (
    ushort varType
)

public:
static TypeCode TypeCodeFromVarType (
    unsigned short varType
)

public static TypeCode TypeCodeFromVarType (
    UInt16 varType
)

public static function TypeCodeFromVarType (
    varType : ushort
) : TypeCode

Parameters

varType
The SSIS type code.

Return Value

A system TypeCode.

Remarks

For a list of the Variant data types, see Integration Services Data Types.

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

Variant Data Type	System TypeCode
VT_EMPTY	System.TypeCode.Empty
VT_NULL	System.TypeCode.DBNull
VT_I2	System.TypeCode.Int16
VT_I4	System.TypeCode.Int32
VT_R4	System.TypeCode.Single
VT_R8	System.TypeCode.Double
VT_CY	System.TypeCode.Decimal
VT_DATE	System.TypeCode.DateTime
VT_BSTR	System.TypeCode.String
VT_DISPATCH	System.TypeCode.Object
VT_ERROR	System.TypeCode.Object
VT_BOOL	System.TypeCode.Boolean
VT_VARIANT	System.TypeCode.Object
VT_UNKNOWN	System.TypeCode.Object
VT_DECIMAL	System.TypeCode.Decimal
VT_I1	System.TypeCode.SByte
VT_UI1	System.TypeCode.Byte
VT_UI2	System.TypeCode.UInt16
VT_UI4	System.TypeCode.UInt32
VT_I8	System.TypeCode.Int64
VT_UI8	System.TypeCode.UInt64
VT_INT	System.TypeCode.Int16
VT_UINT	System.TypeCode.UInt16
VT_VOID	System.TypeCode.Empty

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