Source – ODBC is not compatible with this version of the DataFlow

All we need is an easy explanation of the problem, so here it is.

After deploying an SSIS package from a development server to another environment, execution and validation of the package fail with the following error:

Error: The version of #5) Source – ODBC – Greenplum [object name] is not compatible with this version of the DataFlow

The SQL Server and Greenplum ODBC driver versions are the same on all relevant servers. The servers are running SQL Server 2016, and SQL Server Management Studio 2017 is being used to deploy the package between servers.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Deploying the package with SQL Server Management Studio 2016 resolved the issue.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply