Edit

Share via

Data type support

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

SSIS components use Teradata Parallel Transporter API (TPT API) to load and transfer data from and to Teradata Database, thus only TPT API supported data type can be used in SSIS.

Note

TIME, TIMESTAMP, and INTERVAL data types in Teradata are handled by TPT API as fixed-sized character strings. They are handled by the SSIS components for Teradata as a string.

Data type mapping

The following table shows the Teradata database data types and their default mapping to SSIS data types. It also shows the unsupported Teradata data types.

SQL Data Type SSIS Data Type
DECIMAL/NUMERIC DT_NUMERIC
BYTEINT DT_I1
SMALLINT DT_I2
INTEGER DT_I4
FLOAT/REAL/DOUBLE PRECISION DT_R8
DATE DT_DBDATE
TIME
TIME(n)		 DT_STR
TIMESTAMP
TIMESTAMP (n)		 DT_STR
TIME WITH TIMEZONE
TIME(n) WITH TIMEZONE		 DT_STR
TIMESTAMP WITH TIMEZONE
TIMESTAMP(n) WITH TIMEZONE		 DT_STR
INTERVAL YEAR
INTERVAL YEAR (n)		 DT_STR
INTERVAL YEAR TO MONTH
INTERVAL YEAR (n) TO MONTH		 DT_STR
INTERVAL MONTH
INTERVAL MONTH (n)		 DT_STR
INTERVAL DAY
INTERVAL DAY (n)		 DT_STR
INTERVAL DAY TO HOUR
INTERVAL DAY (n) TO HOUR		 DT_STR
INTERVAL DAY TO MINUTE
INTERVAL DAY (n) TO MINUTE		 DT_STR
INTERVAL DAY TO SECOND
INTERVAL DAY (n) TO SECOND
INTERVAL DAY TO SECOND (m)
INTERVAL DAY (n) TO SECOND (m)		 DT_STR
INTERVAL HOUR
INTERVAL HOUR (n)		 DT_STR
INTERVAL HOUR TO MINUTE
INTERVAL HOUR (n) TO MINUTE		 DT_STR
INTERVAL HOUR TO SECOND
INTERVAL HOUR (n) TO SECOND
INTERVAL HOUR TO SECOND (m)
INTERVAL HOUR (n) TO SECOND (m)		 DT_STR
INTERVAL MINUTE
INTERVAL MINUTE (n)		 DT_STR
INTERVAL MINUTE TO SECOND
INTERVAL MINUTE (n) TO SECOND
INTERVAL MINUTE TO SECOND (m)
INTERVAL MINUTE (n) TO SECOND (m)		 DT_STR
INTERVAL SECOND
INTERVAL SECOND (n)
INTERVAL SECOND (n,m)		 DT_STR
PERIOD(DATE) DT_STR
PERIOD(TIME) DT_STR
NUMBER DT_STR
CHARACTER DT_STR
VARCHAR DT_STR (DT_WSTR for Unicode character set)
Notes:
Maximum length of VARCHAR supported is 32000.
Maximum allowed length of DT_STR is 8000 characters, DT_WSTR is 4000 characters. Data is truncated if exceeds.
LONG VARCHAR Not supported
CLOB Not supported
BYTE DT_BYTES
Note: Maximum allowed length is 8000 bytes. Data is truncated if exceeds.
VARBYTE DT_BYTES
Note: Maximum allowed length is 8000 bytes. Data is truncated if exceeds.
BLOB Not supported

Next steps