SSIS Datatypes

Data type Description

DT_BOOL A Boolean value.
DT_BYTES A binary data value.
The length is variable and the maximum length is 8000 bytes.
DT_CY A currency value.
This data type is an eight-byte signed integer with a scale of 4 and a maximum precision of 19.
DT_DATE A date structure that consists of year, month, day, and hour.
DT_DBDATE A date structure that consists of year, month, and day.
DT_DBTIME A time structure that consists of hour, minute, and second.
DT_DBTIMESTAMP A timestamp structure that consists of year, month, hour, minute, second, and fraction.
DT_DECIMAL An exact numeric value with a fixed precision and a fixed scale. This data type is a 12-byte unsigned integer with a separate sign, a scale of 0 to 28, and a maximum precision of 29.
DT_FILETIME A 64-bit value that represents the number of 100-nanosecond intervals since January 1, 1601.
DT_GUID A globally unique identifier (GUID).
DT_I1 A one-byte, signed integer.
DT_I2 A two-byte, signed integer.
DT_I4 A four-byte, signed integer.
DT_I8 An eight-byte, signed integer.
DT_NUMERIC An exact numeric value with a fixed precision and scale. This data type is a 16-byte unsigned integer with a separate sign, a scale of 0 - 38, and a maximum precision of 38.
DT_R4 A single-precision floating-point value.
DT_R8 A double-precision floating-point value.
DT_STR A null-terminated ANSI/MBCS character string with a maximum length of 8000 characters.
DT_UI1 A one-byte, unsigned integer.
DT_UI2 A two-byte, unsigned integer.
DT_UI4 A four-byte, unsigned integer.
DT_UI8 An eight-byte, unsigned integer.
DT_WSTR A null-terminated Unicode character string with a maximum length of 4000 characters.
DT_IMAGE A binary value with a maximum size of 231-1 (2,147,483,647) bytes. DT_NTEXT A Unicode character string with a maximum length of 230 - 1 (1,073,741,823) characters.
DT_TEXT An ANSI/MBCS character string with a maximum length of 231-1 147,483,647) characters.