Метод DtsConvert.VarTypeFromTypeCode
Converts a system TypeCode to an Службы Integration Services Variant data type.
Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (в Microsoft.SqlServer.ManagedDTS.dll)
Синтаксис
'Декларация
Public Shared Function VarTypeFromTypeCode ( _
typeCode As TypeCode _
) As UShort
'Применение
Dim typeCode As TypeCode
Dim returnValue As UShort
returnValue = DtsConvert.VarTypeFromTypeCode(typeCode)
public static ushort VarTypeFromTypeCode(
TypeCode typeCode
)
public:
static unsigned short VarTypeFromTypeCode(
TypeCode typeCode
)
static member VarTypeFromTypeCode :
typeCode:TypeCode -> uint16
public static function VarTypeFromTypeCode(
typeCode : TypeCode
) : ushort
Параметры
- typeCode
Тип: System.TypeCode
The system https://go.microsoft.com/fwlink/?LinkId=25731 TypeCode to convert to the SSIS type.
Возвращаемое значение
Тип: System.UInt16
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.
System TypeCode |
Variant Data Type |
---|---|
System.TypeCode.Empty |
VT_EMPTY |
System.TypeCode.DBNull |
VT_NULL |
System.TypeCode.Int16 |
VT_I2 |
System.TypeCode.Int32 |
VT_I4 |
System.TypeCode.Single |
VT_R4 |
System.TypeCode.Double |
VT_R8 |
System.TypeCode.Decimal |
VT_CY |
System.TypeCode.DateTime |
VT_DATE |
System.TypeCode.String |
VT_BSTR |
System.TypeCode.Object |
VT_DISPATCH |
System.TypeCode.Object |
VT_ERROR |
System.TypeCode.Boolean |
VT_BOOL |
System.TypeCode.Object |
VT_VARIANT |
System.TypeCode.Object |
VT_UNKNOWN |
System.TypeCode.Decimal |
VT_DECIMAL |
System.TypeCode.SByte |
VT_I1 |
System.TypeCode.Byte |
VT_UI1 |
System.TypeCode.UInt16 |
VT_UI2 |
System.TypeCode.UInt32 |
VT_UI4 |
System.TypeCode.Int64 |
VT_I8 |
System.TypeCode.UInt64 |
VT_UI8 |
System.TypeCode.Int16 |
VT_INT |
System.TypeCode.UInt16 |
VT_UINT |
System.TypeCode.Empty |
VT_VOID |
Примеры
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