Sunday 10 August 2014

SQL Server vs SSIS Data Types



SQL server
SSIS
smallint
two-byte signed intger (DT_I2)
int
four-byte signed integer (DT_I4)
bigint
eight-byte signed integer (DT_I8)
float
double-precision float (DT_R8)
char,varchar
string (DT_STR)
nchar,nvarchar
unicode string (DT_WSTR)
decimal,numeric
numeric(DT_NUMERIC)
decimal
decimal (DT_DECIMAL)
smallmoney,money
currency (DT_CY)
date
database date (DT_DBDATE)
datetime
database timestamp (DT_DBTIMESTAMP)


 
For More Information click on below link:

No comments:

Post a Comment