SQL Server vs SSIS Data Types

SQL server	SSIS
smallint	two-byte signed intger (DT_I2)
int	four-byte signed integer (DT_I4)
bigint	eight-byte signed integer (DT_I8)
float	double-precision float (DT_R8)
char,varchar	string (DT_STR)
nchar,nvarchar	unicode string (DT_WSTR)
decimal,numeric	numeric(DT_NUMERIC)
decimal	decimal (DT_DECIMAL)
smallmoney,money	currency (DT_CY)
date	database date (DT_DBDATE)
datetime	database timestamp (DT_DBTIMESTAMP)

 
For More Information click on below link:

• SSIS Expressions