
Always wondered how SSIS is fuzzy about data types and wanted to know where the metadata got stored.
The metadata can be viewed when the data flow connector (the green arrow) is double clicked or right clicked. This also indicates the origin ot the component along with the data types and other information like code page etc.,