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.

範例

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

請參閱

參考

DtsConvert 類別

Microsoft.SqlServer.Dts.Runtime 命名空間