SQL Server Integration Services Data Conversion Transform Data Types don’t match up to SQL Server Data Types, which makes sense since SSIS isn’t just SQL to SQL.
I found this MSDN article really helpful, albeit, noting the caveat stated on the MSDN page: “These mappings are not intended to represent strict equivalency”
Pulled from the above article, my top 8 are below.
- int – DT_I4
- datetime – DT_DBTIMESTAMP (I don’t get it either)
- nvarchar – DT_WSTR (give length separately)
- varchar – DT_STR (give length separately)
- datetime2 – DT_DBTIMESTAMP2 (use for Oracle DATE/TIMESTAMP compatibility, dates less than 1753 etc)
- bit – DT_BOOL
- float – DT_R8
- bigint – DT_I8