It can be extremely confusing when you first encounter SSIS data types. At first glance, they seem to be nothing like SQL Server data types you love and know. That’s why I’ve provided below a conversion chart of SSIS data types to SQL Server data types. This information is readily available on MSDN but it always seems difficult to find. Hope this helps!
http://www.sqlservercentral.com/blogs/dknight/2010/12/22/ssis-to-sql-server-data-type-translations/
