Welcome to Julian Kuiters Friday, July 20 2018 @ 04:34 PM AEST

Converting SSIS Data Types to .Net Data Types

  • Contributed by:
Integration Services 2005 / SSIS (DTS)

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.