Recently, while working on SSIS to get data from AX and putting in our staging tables, we faced a weird compatibility issue between SQL Server and SSDT version we were using.
We were using database as SQL Server 2012 and SSDT for VS 2013. After completing our development, while executing the package from SSDT, it was working fine. So, we deployed the package to SQL Server. The deployment was successful.
When we executed the package from SQL Server, we faced the following error and the package was failing:
“The version number in the package is not valid. The version number can’t be greater that current version number.”
To fix this issue, what we did is, we installed SSDT for VS 2015 and followed the below mentioned steps:
- Right Click on Project –> Select Properties
- Click on Configuration Properties –> General
- Select TargetServerVersion as “SQL Server 2012”
After that we compiled the solution and deployed the packages to SQL Server 2012 again. It was successful. Then we executed the package from SQL Server 2012 and it got executed successfully.
Hope it helps !!