SQL Server and SSIS Data Types

Following table list the data type mapping between SQL Server data type and SSIS data type

SQL Server Data Type	SSIS Data Type
tinyint	DT_UI1
smallint	DT_I2
int	DT_I4
bigint	DT_I8
real	DT_R4
float	DT_R8
decimal	DT_NUMERIC
numeric	DT_NUMERIC
Datetime	DT_DBTIMESTAMP
smalldatetime	DT_DBTIMESTAMP
Date	DT_DATE, DT_DBDATE
bit	DT_BOOL
char	DT_STR
varchar	DT_STR
nchar	DT_WSTR
nvarchar	DT_WSTR
ntext	DT_NTEXT
text	DT_TEXT
uniqueidentifier	DT_GUID
varbinary	DT_BYTES
timestamp	DT_BYTES
binary	DT_BYTES
xml	DT_WSTR
image	DT_IMAGE
sql_Variant	DT_WSTR
smallmoney	DT_CY
money	DT_CY