Application.DataTypeInfoFromDataType Method (DataType)
Applies To: SQL Server 2016 Preview
Returns the DataTypeInfo object for the specified data type.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
[CLSCompliantAttribute(false)]
public DataTypeInfo DataTypeInfoFromDataType(
DataType dt
)
public:
[CLSCompliantAttribute(false)]
DataTypeInfo^ DataTypeInfoFromDataType(
DataType dt
)
[<CLSCompliantAttribute(false)>]
member DataTypeInfoFromDataType :
dt:DataType -> DataTypeInfo
<CLSCompliantAttribute(False)>
Public Function DataTypeInfoFromDataType (
dt As DataType
) As DataTypeInfo
Parameters
dt
Type: Microsoft.SqlServer.Dts.Runtime.Wrapper.DataTypeThe data type.
Return Value
Type: Microsoft.SqlServer.Dts.Runtime.DataTypeInfo
A DataTypeInfo object.
Remarks
This method lets you get data type information for a specific data type. For example, if you pass "DT_I4" in the dt parameter, the return value is the DataTypeInfo object that contains the enumeration name of "DT_I4" and the type name of "four-byte signed integer". This information is useful for displaying the type information in a user interface or error message. For more information about data types, see Integration Services Data Types.
Notes to Callers:
This method requires the addition of the Microsoft.SqlServer.Dts.Runtime.Wrapper to the project. In the C# code example, the using directive has aliased this namespace with the variable, Wrapper.
Examples
Legacy Code Example
The following code example retrieves the name of the type, DT_I4.
#region Using directives
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Wrapper = Microsoft.SqlServer.Dts.Runtime.Wrapper;
#endregion
namespace Application_and_Package
{
class PackageTest
{
static void Main(string[] args)
{
Application app = new Application();
DataTypeInfo dti = app.DataTypeInfoFromDataType(Wrapper.DataType.DT_I4);
Console.WriteLine("DataType = " + dti.TypeName);
}
}
}
#Region "Using directives
Imports System
Imports System".Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Wrapper = Microsoft.SqlServer.Dts.Runtime.Wrapper
#End Region
Namespace Application_and_Package
Class PackageTest
Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim dti As DataTypeInfo = app.DataTypeInfoFromDataType(Wrapper.DataType.DT_I4)
Console.WriteLine("DataType = " + dti.TypeName)
End Sub
End Class
End Namespace
Sample Output:
DataType = four-byte signed integer
See Also
Application Class
Microsoft.SqlServer.Dts.Runtime Namespace
Return to top