SSIS
SSIS Data types
SSIS Numeric Data types:
| SSIS Data type | Details |
|---|---|
| DT_I1 | single-byte signed integer |
| DT_I2 | two-byte signed integer |
| DT_I4 | four-byte signed integer |
| DT_I8 | eight-byte signed integer |
| DT_UI1 | single-byte unsigned integer |
| DT_UI2 | two-byte unsigned integer |
| DT_UI4 | four-byte unsigned integer |
| DT_UI8 | eight-byte unsigned integer |
| DT_R4 | float |
| DT_R8 | double-precision float |
| DT_Numeric | numeric |
| DT_Decimal | decimal |
| DT_CY | currency |
SSIS String Data types:
| SSIS Data type | Details |
|---|---|
| DT_STR | String |
| DT_WSTR | Unicode text |
| DT_Text | text |
| DT_Ntext | Unicode string |
SSIS Date Data types:
| SSIS Data type | Details |
|---|---|
| DT_Date | Year, month,day,hour,min,sec,fractional secs(7 digits) |
| DT_DBDate | Year, month, day |
| DT_DBTime | hour, min, sec |
| DT_DBTime2 | hour, min, sec, fractional secs(7 digits) |
| DT_DBTimestamp | Year, month, day, hour, min, sec, fractional secs(3 digits) |
| DT_DBTimestamp2 | Year, month, day, hour, min, sec, fractional secs(7 digits) |
| DT_DBTimestampoffset | timestamp with timezone |
SSIS other Data types:
| SSIS Data type | Details |
|---|---|
| DT_Bool | boolean |
| DT_GUID | unique identifier |
| DT_Bytes | Byte stream |
| DT_Image | Image |