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