Tag Archives: ssis casting

…Casting SSIS Data Types – Cheque Please !

Next time you run into Data Conversion errors within SSIS, be sure to read this concise reference on compatible SSIS Casting operations.  Note – Black = Legal, Red = Illegal.

Casting SSIS Data Types Conversion Matrix

Casting explicitly converts an expression from one data type to a different data type. The cast operator can also function as a truncation operator – for example, casting from a DT_WSTR to a DT_STR with the same charcount value may cause truncation of the final characters in the converted string.