SSIS - Tinyint datatype issue

The stage I prefer is the design of the database. Using the most appropriate datatype, creating triggers, indexes, etc. I like that!

Recently I encountered an issue with SSIS where a field having the TINYINT SQL datatype was converted by SSIS in unsigned unicode data type. Of course, the destination field and this field did not match anymore.

The solution is to use a Derived Column component to convert back the data type to the signed unicode data type.

Thanks to the post of Simons, I was able to find the workaround:
http://sqlblogcasts.com/blogs/simons/archive/2006/02/24/SSIS-data-flows-and-tinyint.aspx