DtsConvert.TypeCodeFromVarType Method
Converts a Variant data type to a system TypeCode.
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
'Usage
Dim varType As UShort
Dim returnValue As TypeCode
returnValue = DtsConvert.TypeCodeFromVarType(varType)
public static TypeCode TypeCodeFromVarType(
ushort varType
)
public:
static TypeCode TypeCodeFromVarType(
unsigned short varType
)
static member TypeCodeFromVarType :
varType:uint16 -> TypeCode
public static function TypeCodeFromVarType(
varType : ushort
) : TypeCode
Parameters
- varType
Type: System.UInt16
The SSIS type code.
Return Value
Type: System.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 |