SSIS Raw Data Import Into SQL Server 2008 R2 - Truncation and Condensed Data Type [Intro]
I have written a two pack SSIS solution to perform a scheduled hourly update of data from multiple tables in a single db (SRC) to single table on another db (TRG).

I get the following errors and I understand them:

[ADO NET Destination [328]] Error: An exception has occurred during data insertion, 
    the message returned from the provider is: 
* String or binary data would be truncated.
* The statement has been terminated.

I Know that the data from SRC in some columns is too large for the data in the TRG matching column.  For instance SRC.CompositeAddress is nvarchar(50) and TRG.Addr is char(6)  (same size as Condensed Data Type) which does not make sense for an address

[Question]
My question revolves around not really understanding the condensed data type.  Aside from data in SRC being too large for data in TRG I am wondering if condensed data type is affecting my SSIS import?
AFAIK a condensed type is only an alias used in Management Studio, it's nothing else then the definition of the Type including length information (instead of having two fields: Type and Length - Varchar and 60, you have only one = Varchar(60)).

Now, that error of yours happens obviously because of data truncation. In order for it to pass, you need the original and the source to be of the same type and length (either NVARCHAR(50) or CHAR(6)). For the length it's more important that the source is smaller than the destination.

So you need to pick your necessary type (according to the input data or the destination) and make them both similar. If the input data needs a cleanup, then you better prepare it before inserting it.