DtsConvert.TypeCodeFromVarType(UInt16) Method

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Converts a Variant data type to a system TypeCode.

public:
 static TypeCode TypeCodeFromVarType(System::UInt16 varType);

public static TypeCode TypeCodeFromVarType (ushort varType);

static member TypeCodeFromVarType : uint16 -> TypeCode

Public Shared Function TypeCodeFromVarType (varType As UShort) As TypeCode

Parameters

varType: UInt16

The SSIS type code.

Returns

TypeCode

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

Applies to