SSIS Data types: Change from the Advanced Editor vs Data Conversion Transformations

In this article, I will first give an overview of SSIS data types and data types conversion methods and then I will illustrate the difference between changing the columns data types from the Source Advanced editor and using Data Conversion Transformation.