SSIS: “The version number in the package is not valid. The version number can’t be greater that current version number”

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:

  1. Right Click on Project –> Select Properties
  2. Click on Configuration Properties –> General
  3. Select TargetServerVersion as “SQL Server 2012”

SSIS

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 !!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s