…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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s