Mapping SSIS Data Conversion Transform Data Types to SQL Data Types

 

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