When I was
working with SSIS packages initially, I often used to confuse with SSIS data
types. Now, I used to it since I have been working with them. So, I want to
blog this article so that the newbies can be benefited with this.
|
SSIS Data Type
|
SSIS Data Type Description
|
SQL Server Data Type
|
|
DT_WSTR
|
Unicode string
|
nchar, nvarchar, sql_variant, xml
|
|
DT_STR
|
string
|
char, varchar
|
|
DT_BOOL
|
Boolean
|
bit
|
|
DT_GUID
|
unique identifier
|
uniqueidentifier
|
|
DT_R4
|
float
|
real
|
|
DT_CY
|
currency
|
smallmoney, money
|
|
DT_DBDATE
|
database date
|
date
|
|
DT_DBTIME
|
database time
|
time
|
|
DT_DBTIME2
|
database time with precision
|
time
|
|
DT_DBTIMESTAMP
|
database timestamp
|
datetime, smalldatetime
|
|
DT_R8
|
double-precision float
|
float
|
|
DT_I2
|
two-byte signed integer
|
smallint
|
|
DT_I4
|
four-byte signed integer
|
int
|
|
DT_I8
|
eight-byte signed integer
|
bigint
|
|
DT_UI1
|
single-byte unsigned integer
|
tinyint
|
|
DT_DATE
|
date
|
date
|
|
DT_NUMERIC
|
numeric
|
decimal, numeric
|
|
DT_BYTES
|
byte stream
|
binary, varbinary, timestamp
|
|
DT_DBTIMESTAMP2
|
database timestamp with precision
|
datetime2
|
|
DT_DBTIMESTAMPOFFSET
|
database timestamp with timezone
|
datetimeoffset
|
|
DT_DECIMAL
|
decimal
|
decimal
|
|
DT_IMAGE
|
image
|
image
|
|
DT_TEXT
|
text stream
|
text
|
|
DT_NTEXT
|
Unicode string
|
ntext
|
