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 |
