Export (0) Print
Expand All
Expand Minimize

DataType Enumeration

Indicates the data type of columns in data flow components and the data flow buffer.

Namespace: Microsoft.SqlServer.Dts.Runtime.Wrapper
Assembly: Microsoft.SqlServer.DTSRuntimeWrap (in microsoft.sqlserver.dtsruntimewrap.dll)

public enum DataType
public enum DataType
public enum DataType

Member nameDescription
DT_BOOLA Boolean value.
DT_BYREF_BOOLA pointer to a Boolean value.
DT_BYREF_CYA pointer to a currency value. This data type is an 8-byte value with a scale of 4 and a maximum precision of 19.
DT_BYREF_DATEA pointer to a date structure that consists of year, month, date, and hour.
DT_BYREF_DBDATEA pointer to a date structure that consists of year, month, and date.
DT_BYREF_DBTIMEA pointer to a time structure that consists of hour, minute, and second.
DT_BYREF_DBTIMESTAMPA pointer to a timestamp structure that consists of year, month, hour, minute, second, and fraction.
DT_BYREF_DECIMALA pointer to an exact numeric value with a fixed precision and a fixed scale. This data type is a 12-byte value with a separate sign, a scale of 0 to 28, and a maximum precision of 29.
DT_BYREF_FILETIMEA pointer to a 64-bit value that represents the number of 100-nanosecond intervals since January 1, 1601.
DT_BYREF_GUIDA pointer to a GUID.
DT_BYREF_I1A pointer to a 1-byte, signed integer.
DT_BYREF_I2A pointer to a 2-byte, signed integer.
DT_BYREF_I4A pointer to a 4-byte, signed integer.
DT_BYREF_I8A pointer to an 8-byte, signed integer.
DT_BYREF_NUMERICA pointer to an exact numeric value with a fixed precision and scale. This data type is a 16-byte value with a separate sign, a scale of 0 to 38, and a maximum precision of 38.
DT_BYREF_R4A pointer to a single-precision floating-point value.
DT_BYREF_R8A pointer to a double-precision floating-point value.
DT_BYREF_UI1A pointer to a 1-byte, unsigned integer.
DT_BYREF_UI2A pointer to a 2-byte, unsigned integer.
DT_BYREF_UI4A pointer to a 4-byte, unsigned integer.
DT_BYREF_UI8A pointer to an 8-byte, unsigned integer.
DT_BYTESA binary data value. The length is variable and the maximum length is 8,000 bytes.
DT_CYA currency value. This data type is an 8-byte value with a scale of 4 and a maximum precision of 19.
DT_DATEA date structure that consists of year, month, day, and hour.
DT_DBDATEA date structure that consists of year, month, and date.
DT_DBTIMEA time structure that consists of hour, minute, and second.
DT_DBTIMESTAMPA timestamp structure that consists of year, month, hour, minute, second, and fraction.
DT_DECIMALAn exact numeric value with a fixed precision and a fixed scale. This data type is a 12-byte value with a separate sign, a scale of 0 to 28, and a maximum precision of 29.
DT_EMPTYA data type that does not have a value.
DT_FILETIMEA 64-bit value that represents the number of 100-nanosecond intervals since January 1, 1601.
DT_GUIDA globally unique identifier (GUID).
DT_I1A 1-byte, signed integer.
DT_I2A 2-byte, signed integer.
DT_I4A 4-byte, signed integer.
DT_I8An 8-byte, signed integer.
DT_IMAGEA binary value with a maximum size of 231–1 (2,147,483,647) bytes.
DT_NTEXTA Unicode character string with a maximum length of 2^30–1 (1,073,741,823) characters.
DT_NULLA data type with a value of NULL.
DT_NUMERICAn exact numeric value with a fixed precision and scale. This data type is a 16-byte value with a separate sign, a scale of 0 to 38, and a maximum precision of 38.
DT_R4A single-precision floating-point value.
DT_R8A double-precision floating-point value.
DT_STRA null-terminated ANSI/MBCS character string.
DT_TEXTAn ANSI/MBCS character string with a maximum length of 231–1 (2,147,483,647) characters.
DT_UI1A 1-byte, unsigned integer.
DT_UI2A 2-byte, unsigned integer.
DT_UI4A 4-byte, unsigned integer.
DT_UI8An 8-byte, unsigned integer.
DT_WSTRA null-terminated Unicode character string.

Updated text: 17 July 2006

Data types are divided into reference types and value types. Reference types point to an object of the specified type. Value types contain the actual data, not a pointer to the data.

For those data types that are value types, there are times where you need a pointer to their data, not the data itself. In the member table, the DT_BYREF* members are fields that were created to be pointers to value types.

For more information, see Mapping Data Types in the Data Flow.

ms213438.note(en-US,SQL.90).gifNote:
Boolean values are logical values, not numbers. Although Boolean values may be displayed as numbers in some environments, they are not stored as numbers, and various programming languages represent Boolean values as numeric values differently, as do the .NET Framework methods. For example, the conversion functions available in Visual Basic convert True to -1; however, the System.Convert.ToInt32 method in the .NET Framework converts True to +1. The Integration Services Expression Language converts True to -1. To avoid errors or unexpected results, you should not write code that relies on particular numeric values for True and False. Wherever possible, you should restrict usage of Boolean variables to the logical values for which they are designed.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Release

History

17 July 2006

Changed content:
  • Explained issues that can occur when Boolean values are treated as integers.

14 April 2006

Changed content:
  • Updated description for DT_DATE.

Community Additions

ADD
Show:
© 2014 Microsoft