If you use Scripting tasks, the CLR or build components for SSIS, you will
need to convert values from their SSIS types into .Net types. Here’s a quick
list of the SSIS data types and their .Net companion.
| Integration Services Data Types |
Managed Data Type |
|---|---|
| DT_WSTR DT_TEXT DT_STR |
System.String |
| DT_BYTES DT_IMAGE |
System.Byte[] |
| DT_DBTIMESTAMP DT_DATE |
System.DateTime |
| DT_NUMERIC DT_DECIMAL |
System.Decimal |
| DT_I1 |
System.Byte |
| DT_I2 |
System.Int16 |
| DT_I4 |
System.Int32 |
| DT_I8 |
System.Int64 |
| DT_BOOL |
System.Boolean |
| DT_R4 |
System.Single |
| DT_R8 |
System.Double |
| DT_UI1 |
System.Byte |
| DT_UI2 |
System.UInt16 |
| DT_UI4 |
System.UInt32 |
| DT_UI8 |
System.UInt64 |
| DT_GUID | System.Guid |
Books Online also
lists these conversions.