We've recently installed SQL Server 2016 on development including SSIS, and we're in the process of migrating our work over to this new server. Part of this work involves migrating packages that involve interfacing with other DBMSs. To do that, I need to install connector drivers again. I know that for past versions of SSIS you had to install both the 32 and 64 bit versions of ODBC connector drivers, as parts of SSIS ran in 32-bit no matter what while other parts might run in 64-bit. Does this behavior and requirement hold for SSIS 2016, or does it suffice to just install the 64-bit drivers now?
In the case of DBMSs that only offer ODBC connectors to interface with SSIS (Among other things) the answer is that only the 32-bit connector needs to be installed to make an ODBC data source that SSIS 2016 can recognize. For my environment this was the case with IBM Informix and Progress OpenEdge.
In the case of Oracle the prevailing wisdom I read back when I was working with SSIS 2012 still applies. I had to install both the 32 and 64 bit instant clients, configure symbolic links so that Windows could leverage both of them as it needed, and make the appropriate TNS files and environment variables for the Oracle connector to function.
MySQL worked with just the most recent, 64-bit .NET connector. The same applied to Teradata. It seems that only ODBC connectors and Oracle need 32-bit access.