DtsConvert.VarTypeFromTypeCode Method

Converts a system TypeCode to an Integration Services Variant data type.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
Public Shared Function VarTypeFromTypeCode ( _
    typeCode As TypeCode _
) As UShort
'Usage
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

Parameters

• typeCode
  Type: System.TypeCode
  The system https://go.microsoft.com/fwlink/?LinkId=25731 TypeCode to convert to the SSIS type.

Return Value

Type: System.UInt16
The SSIS type for the system TypeCode.

Remarks

For a list of the SSIS types, see Integration Services Data Types.

The following table shows the TypeCode and what SSIS Variant data type they are converted to.

Examples

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

See Also

Reference

DtsConvert Class

Microsoft.SqlServer.Dts.Runtime Namespace