SSIS data types VS SQL Server data types
Many times we are in need of cross-references between SQL Server data types and the data types available with SQL Server Integration Services. SSIS Data Type SSIS Expression SQL Server single-byte signed integer (DT_I1) two-byte signed integer (DT_I2) smallint four-byte signed integer (DT_I4) int four-byte signed integer (DT_I4) int eight-byte signed integer (DT_I8) bigint eight-byte signed integer (DT_I8) bigint float (DT_R4) real double-precision float (DT_R8) float string (DT_STR, «length», «code_page») char, varchar Unicode text stream (DT_WSTR, «length») nchar, nvarchar, sql_variant, xml date (DT_D