SSIS Optimization - Optimum use of data types

This is something very obvious, but many will fail to implement it. It is such an important point that it needs to be made separately. Follow the below guidelines:

Make data types as narrow as possible so you will allocate less memory for your transformation.
Do not perform excessive casting of data types – it will only degrade performance. Match your data types to the source or destination and explicitly specify the necessary data type casting.
Watch precision issues when using the money, float, and decimal types. Also, be aware the money is faster than decimal, and money has fewer precision considerations than float.