I have a SSIS 2012 package running on SQL Server 2016.
My ODBC source is Filemaker. I have both the 32bit and 64bit version of the Filemaker ODBC driver installed on the server running SQL Server at the System DSN level.
When I run the package in VS2015 installed on the server, everything works fine. But when I deploy the package on SQL Server 2016 (same machine) and execute it from there I get this error:
Data Flow Task: The version of FM Source (my ODBC source task) in Data Flow is not compatible with this version of the DataFlow.
What is wrong?