DtsConvert.TypeCodeFromVarType Method

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

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntaxe

'Déclaration
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

Paramètres

varType
The SSIS type code.

Valeur de retour

A system TypeCode.

Notes

For a list of the Variant data types, see Types de données d'Integration Services.

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

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles