SSIS data type to SQL Server data type
SSIS Data Type
|
SQL Server Data Type
|
DT_BOOL
|
bit
|
DT_BYTES
|
binary, varbinary, timestamp
|
DT_CY
|
smallmoney, money
|
DT_DBDATE
|
date (Transact-SQL)
|
DT_DBTIME2
|
time (Transact-SQL)(p)
|
DT_DBTIMESTAMP
|
datetime (Transact-SQL)
|
DT_DBTIMESTAMP2
|
datetime2 (Transact-SQL)
|
DT_DBTIMESTAMPOFFSET
|
datetimeoffset (Transact-SQL) (p)
|
DT_GUID
|
uniqueidentifier
|
DT_I2
|
smallint
|
DT_I4
|
int
|
DT_I8
|
bigint
|
DT_NUMERIC
|
decimal, numeric
|
DT_R4
|
real
|
DT_R8
|
float
|
DT_STR
|
char, varchar
|
DT_UI1
|
tinyint
|
DT_WSTR
|
char, varchar, nchar, nvarchar, sql_variant, xml
|
DT_IMAGE
|
image
|
DT_NTEXT
|
text, ntext
|
DT_TEXT
|
text
|
