| 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 |
eight-byte signed integer | (DT_I8) | bigint |
single-byte unsigned integer | (DT_UI1) | tinyint |
two-byte unsigned integer | (DT_UI2) | |
four-byte unsigned integer | (DT_UI4) | |
eight-byte unsigned integer | (DT_UI8) | |
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 |
Book Review: Big Red - Voyage of a Trident Submarine
I've grown up reading Tom Clancy and probably most of you have at least seen Red October, so this book caught my eye when browsing used books for a recent trip. It's a fairly human look at what's involved in sailing on a Trident missile submarine...
2009-03-10
1,439 reads