FAQ:SSIS:Data Type Conversions

From Melissa Data Wiki
Jump to navigation Jump to search

← SSIS:Data Quality Components

Conversion chart of SSIS data types to SQL Server data types

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_DATE) date
Boolean (DT_BOOL) bit
numeric (DT_NUMERIC, «precision», «scale») decimal, numeric
decimal (DT_DECIMAL, «scale») decimal
currency (DT_CY) smallmoney, money
unique identifier (DT_GUID) uniqueidentifier
byte stream (DT_BYTES, «length») binary, varbinary, timestamp
database date (DT_DBDATE) date
database time (DT_DBTIME)
database time with precision (DT_DBTIME2, «scale») time(p)
database timestamp (DT_DBTIMESTAMP) datetime, smalldatetime
database timestamp with precision (DT_DBTIMESTAMP2, «scale») datetime2
database timestamp with timezone (DT_DBTIMESTAMPOFFSET, «scale») datetimeoffset(p)
file timestamp (DT_FILETIME)
image (DT_IMAGE) image
text stream (DT_TEXT, «code_page») text
Unicode string (DT_NTEXT) ntext