View source for FAQ:SSIS:Data Type Conversions

[[SSIS:Data Quality Components|&larr; SSIS:Data Quality Components]]

==Conversion chart of SSIS data types to SQL Server data types==

{| class="wikitable"
! style="font-weight: bold;" | SSIS Data Type
! style="font-weight: bold;" | SSIS Expression
! style="font-weight: bold;" | 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