Teradata data type SQL Server Integration Services data type Decimal/backend data types DECIMAL/NUMERIC DT_NUMERIC BYTEINT DT_I1 SMALLINT DT_I2 INTEGER DT_I4 FLOAT/REAL/DOUBLE PRECISION DT_R8 Date/time and interval data types DATE DT_DBDATE TIME DT_STR TIME(n) TIMESTAMP DT_STR TIMESTAMP (n) TIME WITH TIMEZONE DT_STR TIME(n) WITH TIMEZONE TIMESTAMP WITH TIMEZONE DT_STR TIMESTAMP(n) WITH TIMEZONE INTERVAL YEAR DT_STR INTERVAL YEAR (n) INTERVAL YEAR TO MONTH DT_STR INTERVAL YEAR (n) TO MONTH
Teradata data type SQL Server Integration Services data type Decimal/backend data types DECIMAL/NUMERIC DT_NUMERIC BYTEINT DT_I1 SMALLINT DT_I2 INTEGER DT_I4 FLOAT/REAL/DOUBLE PRECISION DT_R8 Date/time and interval data types 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
SSIS_Teradata_Connectors.docx