Just to add an update to this, SSIS 2016 now has an ODBC Source which is found in the "Common" grouping in the SSIS toolbox 🙂 Don't forget that SSDDT is running in 32 bit in the designer and 64 bit during runtime unless you turn the "Run in 64bit" in the project properties. If you create the ODBC driver with the same name in 32bit and 64bit under the same name you will not encounter this error.